main logo
Subject: Re: distinct
Author: Ruslan Zasukhin
Posted: 2002/08/28 16:43:07
 
View Entire Thread
New Search


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
<-- Prior Message New Search Next Message -->