[Linden]

Hi,

I was wondering what the best way to go about making an SQL file generator. Basicly I want a form type application that has some variable fields and prints them on a .sql file with other things.
EG:

/*
$Item_name
*/
INSERT INTO `vendors` VALUES ('$npc_id', '$item_number', '1');

And return something like:

/*
Sword
*/
INSERT INTO `vendors` VALUES ('25000', '29362', '1');

I want it to be able to generate a variable amount in 1 .sql file. ( It's 3am, sorry about the grammar)
EG:


/*
<<<<ONE-HANDED SWORDS>>>>
*/
/*
Talon of Azshara
*/
INSERT INTO `vendors` VALUES ('25000', '30082', '1');
/*
The Sun Eater
*/
INSERT INTO `vendors` VALUES ('25000', '29362', '1');
/*
Fang of the Leviathan
*/
INSERT INTO `vendors` VALUES ('25000', '30095', '1');

Thanks alot.
-Linden

[Advertisements]

What language to you plan on doing this in?

If you are trying to figure that out, I'd recommend Visual Basic .NET or C++. You can get the Microsoft Visual Studio Express version for free in both of those languages, which is built to easily connect to Microsoft SQL Server 2005. You could also use the Microsoft Visual Studio Express version for C# or J#, but those are less commonly used.

[stettybet0]

What language to you plan on doing this in?

If you are trying to figure that out, I'd recommend Visual Basic .NET or C++. You can get the Microsoft Visual Studio Express version for free in both of those languages, which is built to easily connect to Microsoft SQL Server 2005. You could also use the Microsoft Visual Studio Express version for C# or J#, but those are less commonly used.

[Linden]

I have C++ Express 2005, but I just use it to compile a few things right now. I'm not really a C++ Wizz .

[stettybet0]

I have no experience with using SQL with C++. However, This tutorial may be of some use.

[Linden]

Cool, Thanks heaps! Could I also get some help on this from a pro ^___^. I have seen a few parts of a .dll that outputs a "stats.xml" with info about the computer. Eg, ram usage, cpu usage.

[Linden]

Bump. 1 week.