How to Generate an SQL-query

[Frathir]

Hey i am pretty new to visual basic, so i am a big noob :P.

i was wondering if you can make a program, that generates SQL-Query(or just text), depending on what data you've entered in different fields? And if so, How?

plz help me,
Best regards,
Frathir

[Hack]

Welcome to the forums.

I would suggest going through our Database FAQ section.

[Frathir]

OK, will do, thanks!

[abhijit]

I am not able to understand your requirement?

Are you looking for a program that does this for you or do you want to write a program that will automatically generate SQLs?

[sapator]

If it's the second and you want to write your own program then you should have a good understanding of sql.I have done this a couple of years ago(a company did not want to expose the sql to the users and instead they paid us to make a sql like query analyzer).
I cannot give code apparently but i used datatables for simulation.
It took me about a month
But my knowledge was not very good at sql(not that i'm a guru now) so i ended up checking string (with the query code) and cutting double on's and where's and multiple tables.If i remember correctly it was about 7-10000 lines of code, along with the interface,drawing tables,drowning join lines etc
I admit the code was purely written so my advise is to first learn a fair amount of sql before you try this.

[rplcmint]

Frathir,

Both Access and SQL Server have a Query Designer tool that can help generate SQL code and queries. Check it out...