on 8/29/02 0:19, aw (AT) emedien-wegener .D.OT de at aw@emedien-wegener.de wrote:
> Name: Andre > > Question regarding: sql > > How can I implement this in my Lingoscript: TableName.FieldName > without getting the error that FieldName is no property. > Or how can I realize this: > "select distinct TableName.FieldName" > > Thanks for help > > Andre
Hi Andre,
I do not understand...it seems you confuse and mix Lingo with SQL.
Lingo variables are NOT related to SQL. To do SQL query you need simply string.
query = "SELECT distinct TableName.FieldName FROM TableName"
curs = db.SqlSelect( query )
This is all.
Is this answer on your question ?
-- Best regards, Ruslan Zasukhin [ I feel the need...the need for speed ] ------------------------------------------------------------- e-mail: ruslan (AT) paradigmasoft .D.OT com web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list send a letter to valentina-on@lists.macserve.net ------------------------------------------------------------- ©2002 Ruslan Zasukhin |