Dynamic SQL

[Mary10k]

Can anyone suggest a reference for dynamic SQL? I would like to do more research on the subject.

 

[BoxHead]

Mary,

When you say 'dynamic SQL' I assume you mean run-time, module-level SQL.

If you click on tlBroadbent's name on the expert list to the right of the posts you can follow any of the threads he's participated in.

Part of his signature is an FAQ which has links to reference sources in numbers 3 and 4.

Reading some of his posts would probably provide a good deal of insight as well.


HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[zohre]

i will use sql dynamic . sqls have many field different .
exsample:
1)sql have 3 field
2)sql have 5 field
3)sql have 9 field with previous sql is different name field.
please you help .
thank you

 

[tlbroadbent]

I recommend the following Microsoft articles.

ACC2000: Query by Form (QBF) Using Dynamic QueryDef

http://support.microsoft.com/support/kb/articles/Q210/2/42.ASP

ACC2000: How to Simulate Parameters in an SQL Pass-Through Query

http://support.microsoft.com/support/kb/articles/Q232/4/93.ASP

Microsoft provides a downloadable sample database with over 20 different query examples.

http://support.microsoft.com/support/kb/articles/Q207/6/26.ASP

Microsoft has placed an entire book about Access development on the Web.

http://msdn.microsoft.com/library/en-us/bapp2000/html/ba2000intro.asp

I recommend reading some of the articles at MVPS.ORG. They also include sample code.

http://www.mvps.org/access/forms

http://www.mvps.org/access/queries

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.