Printable View
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? :D
plz help me,
Best regards,
Frathir
Welcome to the forums. :wave:
I would suggest going through our Database FAQ section.
OK, will do, thanks! :)
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?
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 :cry:
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 :cry:
I admit the code was purely written so my advise is to first learn a fair amount of sql before you try this.
Frathir,
Both Access and SQL Server have a Query Designer tool that can help generate SQL code and queries. Check it out...