5 Replies - 2576 Views - Last Post: 05 December 2012 - 10:37 PM Rate Topic: -----

#1 aqibbutt  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 01-December 12

error in vb 6 with oracal . coloumn not allowed here

Posted 01 December 2012 - 08:57 PM

i am getting an error while creating database project in VB.6 n oracal combine and the error is column not allowed here and code is
rs1.Open "insert into pta (name,fname,phoneno,sex) values(" & Text1.Text & "," & Text2.Text & "," & combo2.text & "," & Text6.Text & ") ", con, adOpenDynamic, adLockOptimistic
name n phoneno are composite primary key and phoneno is also foriegn key also and datatype of phone no is number(11) , combo2.text is the value of phone no . so anyone please help me

Is This A Good Question/Topic? 0
  • +

Replies To: error in vb 6 with oracal . coloumn not allowed here

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 572
  • View blog
  • Posts: 2,985
  • Joined: 19-May 09

Re: error in vb 6 with oracal . coloumn not allowed here

Posted 02 December 2012 - 02:01 PM

Recordsets are to get data, not insert it. Use the Command object. Look it up, and post back if you have difficulty. (In other words, don't ask me to write the code for you. :) )
Was This Post Helpful? 0
  • +
  • -

#3 aqibbutt  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 01-December 12

Re: error in vb 6 with oracal . coloumn not allowed here

Posted 02 December 2012 - 10:05 PM

mr. bob thanks for your rply but i want to tell you that i have pointed that where i have done mistake and the mmistake was i was not usind single qoutes for varchar datatype...and i have done with recordset :)
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 572
  • View blog
  • Posts: 2,985
  • Joined: 19-May 09

Re: error in vb 6 with oracal . coloumn not allowed here

Posted 04 December 2012 - 10:27 PM

Well, yes, it will work once you put the quotes in, but I'm just asking you to do it the right way. If you don't care about anything but getting your program to work, no matter how sloppy your code, then you don't need my help anyway.

This post has been edited by BobRodes: 04 December 2012 - 10:30 PM

Was This Post Helpful? 0
  • +
  • -

#5 aqibbutt  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 01-December 12

Re: error in vb 6 with oracal . coloumn not allowed here

Posted 05 December 2012 - 12:23 PM

Mr .bob yes i appriciate your help and yes you are right anyways thats for your precious time i will try the same the way you told me .
Was This Post Helpful? 0
  • +
  • -

#6 aqibbutt  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 01-December 12

Re: error in vb 6 with oracal . coloumn not allowed here

Posted 05 December 2012 - 10:37 PM

mr MOB please tell me one more thing that how to import my data from oracl 11g to 9i please
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1