How do I use dbexpress

[john230873]

I am trying to use DBexpress as the computer I am putting this application on does no have the BDE. I keep getting the "Operation not allowed on unidirectional dataset" which I have read up on and found that I need a
SQLDataSet
DataSetProvider
ClientDataSet

I have worked out how to link the DataSetProvider to the SQLDataSet but how do I link the ClientDataset.

In short my aim is to link to a sql database and view a table in a dbgrid.

Any good reading on this would be great.

 

[towerbase]

Have you read the FAQ on dbExpress in this forum?

Send a comment to me (see end of FAQ) if anything is unclear and I will update the FAQ.


Andrew
Hampshire, UK

 

[john230873]

Cheers
No I didn't I had done a search on this forum and got a lot back I must have missed it.

 

[john230873]

I keep trying the search (last 4 days) but it keeps saying it is under maintenance.

I have an identify field in SQL so I don't want to update it. Each time I try to add a record the dbexpress get upset saying I must update this field. I have populated the field list of the dataset and said that this field is not required but this seems not to solve this issue.

Also does dbexpress work correctly in Delphi 7 ? I can't get it to show metadata or table list for SQL Server 2K

 

[Stretchwickster]

You can navigate to the FAQ section to read the aforementioned FAQ by clicking the "FAQs" button on the silver navigation bar near the top of this page (it's next to the "Search" button).

Clive
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer."
Paul Ehrlich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096