•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 402,808 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,069 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 279 | Replies: 1
 |
•
•
Join Date: Jul 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi friends
I need some help from VB and Oracle guru's.
I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue)
For this purpose I code as follow and get error table name is not valid:-
1. Draw a Text Box on form with name tblNametxt
2. Draw a button on form with name cratblebtn
3. Variable Declaration
4. Established a successful connection between VB 6.0 and Oracle 8i.
5. Code for button
on click at button in running mode I got an error :Table name is invalid
I repeat point 5 as
But again I got an error :Table name is invalid
I again repeat as fixed name as
Then this code is run successfully.
Kindly help to create a table with dynamically assigned name from VB 6.0.
Thanks in advance
I need some help from VB and Oracle guru's.
I am trying to create a dynamic table from VB 6.0 in Oracle (mean I want to create a table whose name is dynamic issue)
For this purpose I code as follow and get error table name is not valid:-
1. Draw a Text Box on form with name tblNametxt
2. Draw a button on form with name cratblebtn
3. Variable Declaration
Dim Cn as ADODB.Connection
Dim Conn as String
Dim vtblNametxt as String5. Code for button
vtblNametxt= tblNametxt.txt Cn.Execute(“create table ‘ ” + vtblNametxt + ” ’ (id varchar2(3), pname varchar2(20), qtyp number(4))”)
I repeat point 5 as
vtblNametxt= tblNametxt.txt Cn.Execute(“create table ” & vtblNametxt & ” (id varchar2(3), pname varchar2(20), qtyp number(4))”)
I again repeat as fixed name as
vtblNametxt= tblNametxt.txt Cn.Execute(“create table sman(id varchar2(3), pname varchar2(20), qtyp number(4))”)
Kindly help to create a table with dynamically assigned name from VB 6.0.
Thanks in advance
Last edited by Tekmaven : Jul 17th, 2008 at 12:33 pm. Reason: Code tags
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: ivrs project
- Next Thread: Saving excel sheet with few column names present as file name
