problem of VFP and MySQL.

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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion