Viewing 5 posts - 136 through 140 (of 140 total)
The Where clause executes after the Inner join (so all records in both tables are inner joined first) then the Where clause reduces the records selected. Move the IN ()...
November 13, 2003 at 8:08 am
In Foxpro the field width includes the decimals, the minus sign and the decimal place('.'). So a number field like -9999.99 needs to be set up as N(8, 2). DTS...
October 29, 2003 at 4:15 am
I believe OPENROWSET works without linking the databases, as long as the PC you are running the query on can see the other server on the network. I may be...
October 3, 2003 at 9:36 am
You can use openrowset() to return a something (I am not sure what) that can be included in a select statement as if it were a table in your current...
October 3, 2003 at 9:17 am
I'm no expert but it looks like the connection timeout has been reached (or maybe just the query timeout). Increase the timeouts on the servers concerned (sorry, I don't know...
September 29, 2003 at 4:00 am
Viewing 5 posts - 136 through 140 (of 140 total)