 |  |  |  |  |  |  |  |
SQL in DataEnvironment....????
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Hi, i am using Data Environment to connect VB with my Access Database.
Can i use SQL statement in my script (manualy)..??
Please tell me how to do it
Thanks
RE
-Denpasar-
Can i use SQL statement in my script (manualy)..??
Please tell me how to do it
Thanks
RE
-Denpasar-
after creating the connection object establish the connection to the database. Right click on connection and add a command object .Right click on the command object and select sqlstatment in the general tab in properties . add the sql statment that you want.
Hope that solves your problem.
Hope that solves your problem.
Share your Knowledge.
•
•
•
•
Originally Posted by debasisdas 
after creating the connection object establish the connection to the database. Right click on connection and add a command object .Right click on the command object and select sqlstatment in the general tab in properties . add the sql statment that you want.
Hope that solves your problem.
I'm trying to use SQL statement in my scripting, not by creating an object
something like
DIM strSQL as STRING
strSQL = "SELECT NamPeg FROM ...."
.....
.....
So i make the SQL statement in my project not by creating command object
•
•
•
•
Originally Posted by ryan_vietnow
for example:
Adodc1.Recordsource="Select * from Table1";
i make connection using Data environment object, not by script...
but thanks anyway, i'll try again, maybe there is something i miss
What bout trying like this.
vb Syntax (Toggle Plain Text)
Share your Knowledge.
Hi,
I have created you a small example of recprdset coding and attached it. Check if it is what you need. If further assistance is needed please reply.
I have created you a small example of recprdset coding and attached it. Check if it is what you need. If further assistance is needed please reply.
It is never about the number of languages you know, you either have the logic of programming or you don't ...
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
|
Similar Threads
- Is it possible to change the SQL Text of Command thr' code which is created in DataEn (Visual Basic 4 / 5 / 6)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Visual basic 6 picture background problem
- Next Thread: noob here! combo box
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
