Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL settings
Message
From
06/08/2003 11:50:39
 
 
To
06/08/2003 11:47:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00817343
Message ID:
00817350
Views:
16
Nick,

Thanx,

Mike
>Michael
>
>Use ==
>
>Nick Mason
>
>>This has to be obvious... I just cant remember...
>>
>>Anyway...
>>
>>I have SET EXACT ON...
>>
>>And am running a select:
>>
>>select postdate,costtype,costcode,costamount ;
>> from jobcost ;
>> where costcode = "1000"
>>
>>the cursor returns with records that have these costcodes:
>>
>>"1000" good
>>"10000" not good
>>"100000" really not good...
>>
>>Shouldnt SET EXACT ON stop that?
>>
>>or...
>>
>>How do I get just "1000"?
>>
>>Thanx,
>>
>>
>>Michael Mead
>>VFP 8.0
Previous
Reply
Map
View

Click here to load this message in the networking platform