Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: D7 + DBX + TDataSetFields

Permlink Replies: 0 Threads: [ Previous | Next ]
Martyn Ayers

Posts: 73
Registered: 10/7/99
D7 + DBX + TDataSetFields
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 14, 2014 7:10 AM
I have a project containing a conventional master-detail pair of
queries, originally TAdoQueries connected to an AdoConnection, a
DataSetProvider connected to the master, a master CDS which gets its
data from the DataSetProvider and a detail CDS which gets its data
from a DataSetField in the master CDS.

This set-up works fine with AdoQueries, but with SqlQueries used
instead (nothing else changed apart from
AdoConnection->SqlConnection), when I attempt to open the master CDS I
get the error "Field qDetail" not found when the master CDS attempts
to do its BindFields.

Fwiw, the server involved is an MS Sql Server 2000 one.

Can anyone suggest what the cause might be?

Fwiw, in an unrelated project which uses multiple result sets from a
stored proc, calling NextRecordSet to get the second one works fine
using Ado components whereas calling NextRecordSet on a SqlStoredProc
returns a dataset with corrupted data in the 3rd and subsequent
columns, which makes me wonder whether DBX in the D7 era wasn't a
shade buggy.

Cheers & TIA
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02