Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

problem of VFP and MySQL.

MaxLeeMaxLee Member Posts: 18
I have a little question about MySQL, i want to use parameter in SQL statement, is it possible?
The scenario is I gotta use Visual FoxPro to create database in MySQL. But what i wanna do in VFP is as follows:

STORE 'SSN' INTO x

SQLEXEC('CREATE TABLE citizen ("X" int)')





/*where x is 'SSN'. After the above statement, there will be a table called citizen with a column SSN in MySQL.


Please give me some hints about that.

Comments

  • MaxLeeMaxLee Member Posts: 18
    : I have a little question about MySQL, i want to use parameter in SQL statement, is it possible?
    : The scenario is I gotta use Visual FoxPro to create database in MySQL. But what i wanna do in VFP is as follows:
    :
    : STORE 'SSN' INTO x
    :
    : SQLEXEC('CREATE TABLE citizen ("X" int)')
    :
    :
    :
    :
    :
    : /*where x is 'SSN'. After the above statement, there will be a table called citizen with a column SSN in MySQL.
    :
    :
    : Please give me some hints about that.
    :



    Hi folks, the previous problem i have already solved myself. Thx.

Sign In or Register to comment.