On Friday 07 April 2006 10:01, johnf wrote:
> On Friday 07 April 2006 09:38, johnf wrote:
> > Hi,
> > It appears that the ODBC connector does not have any code for:
> > "GetSchemaInfoSQL". The other connectors Postgres, MySQL, and Firebird
> > have code to retrieve the schema information - like getting the primary
> > key information. So when using the ODBC connector where and how does one
> > set the schema information for the Tsqlquery control? Without setting
> > the information in the Tsqlquery the applyupdates will not work.
> >
> > Thanks
> > John
>
> It looks like "UpdateIndexDefs" is not defined. Ok, so does that mean I
> can just the add the primary key to "IndexDefs.AddIndexDef" structure? And
> if that's right what is the easy way to add the information and when should
> it be added?
>
> John
sqlquery.fieldbyname('name_that_should_be_in_where_part').providerflags:=pfInkey;
Loesje of the FPC IRC provided the above command to set the primary key. So
try adding the code after you open the sqlquery control.
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
