Skip navigation links

MySQL Forums :: DBF, dBASE, FoxPro, Clipper, xBASE :: Calls to SQl from Foxpro


Advanced Search

Re: Calls to SQl from Foxpro
Posted by: Badita Alexandru Stefan ()
Date: February 21, 2009 03:11PM

But can I make in MySql something like this:

Set @aaa = 1;
Set @DynamicColumnName = Concat('Day',1);

Insert Into MyTable (@DynamicColumnName) Values (@aaa)

It is giving me an error

Basically all I want to be able to do is to make a dynamic column headder that I know it corresponds to one of my columns and update that column with some value. Can this be done in MySql ?

Options: ReplyQuote


Subject Views Written By Posted
Calls to SQl from Foxpro 8320 Brian Paul 08/21/2007 10:18AM
Re: Calls to SQl from Foxpro 4845 donw 08/21/2007 10:39AM
Re: Calls to SQl from Foxpro 5293 Dave Call 12/20/2007 05:58PM
Re: Calls to SQl from Foxpro 4750 Mike Frederick 01/16/2008 12:46PM
Re: Calls to SQl from Foxpro 4488 Arun Markish 02/05/2008 08:17AM
Re: Calls to SQl from Foxpro 3607 Badita Alexandru Stefan 02/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.