MySQL Forums
Forum List  »  Other Migration

Calls to SQl from Foxpro
Posted by: Brian Paul
Date: August 21, 2007 10:18AM

I can not make a call from Foxpro to SQL - It has to do with using a variable

This works:
SQLEXEC(gnConnHandle, 'SELECT * FROM box where box_id=38107')


This does not:
xxx=38107
SQLEXEC(gnConnHandle, 'SELECT * FROM box where box_id=xxx')

Does anyone know a better way of selecting data from SQL from Foxpro?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Calls to SQl from Foxpro
11023
August 21, 2007 10:18AM
6342
August 21, 2007 10:39AM
6860
December 20, 2007 05:58PM
6385
January 16, 2008 12:46PM
5982
February 05, 2008 08:17AM
5238
February 21, 2009 03:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.