When my .net application uses "microsoft visual foxpro odbc driver" to
execute a SQL statement as following:
select * from ordersTable where var(mycolumn) >1000
I got error:
could not find var.prg

I throught var function is supported by the driver, could someone help
me here. Thanks.
Holly Li

--
Posted via http://dbforums.com

Var() is valid as a parameter to the CALCULATE command, not as a standalone
function.

Dan

"hollyli" <member35131 (AT) dbforums (DOT) com> wrote

Thanks.
Then could you tell me how to convert a String to a number?
The situation is that there is a column in table "orders" called
"date" that stores "date" as string of seconds. I wanted to do a
"select " like:
select * from orders where date>somenumber
Since the "date" is stored as string and I don't want to compare String,
I am thinking of converting the "date" to number first. Any ideas?
Thanks a lot.
Holly Li

--
Posted via http://dbforums.com

I had a hunch that's what you were looking for.

Val(String) will convert your string to a number.

or, convert your number to a string: Transform(number)

Dan

"hollyli" <member35131 (AT) dbforums (DOT) com> wrote

hollyli <member35131 (AT) dbforums (DOT) com> wrote:

That is val() not var().

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Thank you very very much!
Holly.

--
Posted via http://dbforums.com