944,027 Members | Top Members by Rank

Ad:
Apr 4th, 2005
0

Is it possible to change the SQL Text of Command thr' code which is created in DataEn

Expand Post »
Hello,
I created command object in DataEnvironment. Now I wish to change to command object's Sql Text since table name gets changed depending upon year of working.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
sham is offline Offline
40 posts
since Mar 2005
Apr 4th, 2005
0

Re: Is it possible to change the SQL Text of Command thr' code which is created in DataEn

Could you be a little more specific, and possibly attach the project and database?
Team Colleague
Reputation Points: 361
Solved Threads: 214
Taboo Programmer
Comatose is offline Offline
2,413 posts
since Dec 2004
Mar 18th, 2009
0

Re: Is it possible to change the SQL Text of Command thr' code which is created in DataEn

Let me try to help in this case, (Since i got the same doubt),

See, there is a DataEnvironment, it has a Connection object and both's required properties set at design time. There is also a Command1 which has a SQL string command which is set during design time.

Now,
At runtime I want to change the Command1's SQL string, but since its a constant value it give an error, how to solve it?
Reputation Points: 26
Solved Threads: 0
Junior Poster in Training
RahulV is offline Offline
92 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: source code for finding eigenvector
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: DataControl giving Visual Studio JIT Debugger win32 exception !





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC