flex grid problem solved , small mistake was there in name of control,
one cause of problem i found was name of table having underscore, but after correcting that , now my code is working for my table but only when i use primary key in where clause , when i try to use non pk column and make query ,for that again it is showing previous error.
my table is hrd1 having columns empno (pk) and exp1 (experience), , both...
mask
Last Activity: Jan 16 '08, 08:23 AM
Joined: Sep 24 '07
Location:
-
i am using hierarchial flex grid control only...Leave a comment:
-
rs.Open Sql, con, adOpenForwardOn ly, adLockReadOnly
same problem persists with the above changes also.
Set MSHFG.Recordset = rs
This also doesn't works , it gives error - no such data member existsLeave a comment:
-
I have a form in vb, controls on that form are a text box, command button , hflexgrid.
My requirement is that when user enters a number in text box , and clicks on command button , recordset should be opened according to a query matching the value entered in textbox , and flexgrid should be associated with recordset and shud display results.
Now this whole thing is working fine with emp table of oracle, but when I...Leave a comment:
-
i am using adcmdtable , i.e. select * from tablename , and the same query i am executing from sql prompt which is returning resultset.
thxLeave a comment:
-
ya its in scott user and cursor type i am using is adopendynamic,l ocktype is adlockoptimisti c , later in order to trace the problem ,i have tried to use refresh method of recordset object also but i am not sure its the correct soln or not
thxLeave a comment:
-
is it related to user rights or privileges etc. problem is coming only with tables i have created, i am using login scott, tiger, shud i login thru some other user?Leave a comment:
-
i have checked that, though there are records in the table , which i am able to see at sql prompt thru a simple sql query , i get rs.eof and rs.bof both as true.
then what cude be the problem?Leave a comment:
-
thx for ur prompt reply , there are records in the table and on form load i want to show the first record so i use movefirst of recordset, but still it gives eof or bof is true or current record has been deleted , the same code is working fine with the sample tables already in oracle like emp or dept.
the same code is working with one more table i created , but the difference b/w the 2 tables is that second table doesn't have any field of...Leave a comment:
-
Oracle Error -either eof or bof is true-connecting with vb thru adoddb
Hi all,
I have a problem of urgent nature . I am using Oracle and VB6 for an application . i am using ADODB coding
In oracle i have created a table and trying to connect thru vb form. the vb code is giving an error "either eof or bof is true or the current record has been deleted "
When i try to use some other tables already there in oracle , with the same code ,its working fine. Also i have tried to use ADODC... -
PL/SQL triggers-how to disable all triggers of a user
I wish to disable all triggers for a particular user.I am using a cursor to select all triggers from user_triggers table whose table_owner is the user. Now inside a cursor DDL statements can't be used to alter the trigger . one solution i have found is to use Execute Immediate stmt for executing DDL stmts in a pl/sql code. but that is also not working when i get the name of the trigger inside a cursor loop and try to use Execute Immediate by making... -
how can that be repaired?do i have to install oracle again?or any other option?
thxLeave a comment:
-
i am using the wizard so no where the service name is asked, where should i give it in that case?i am able to connect to orcale thru the client.
thx...Leave a comment:
-
mask started a topic Error in test Connection VB-oracle--- OracleClient n networking comps not foundin Visual BasicError in test Connection VB-oracle--- OracleClient n networking comps not found
I wish to connect to Oracle thru VB6 using ADO, test connection fails and the error which comes is as Test Connection failed because of error in initialising provider-oracle client and networking components were not found.How can this problem be solved ?
thx n regards -
OracleDefault_HomeTNSListener Service startup error 1067
I wish to connect to oracle from vb6,using ADO, when i use the wizard and try to test the connection , connection fails . When I try to start the oracle services, for the service OracleDefault_H omeTNSListener startup i get the following error code 1067 Process terminated Unexpectedly.How to solve this problem? -
Vb 6.0 Ado
In vb6.0,i wish to use ADO to connect to a Oracle database.Though the Odbc driver for oracle is installed(verif ied), still when I try to connect to the db , in the datalink properties window- option of OLE Db provider for oracle is not coming.Can somebody help out?
thx n regards -
Triggers-Mutating Table
I am writing a trigger for delete event of employee table (PK - empno, Mrgid - Self referencing key ) in oracle .In the trigger , i wish to update the rows of the same table which have mgr id equal to the empno being deleted, and set the mgrid=null. The problem coming here is of Mutating table.Is there a simple workaround of this problem?
Thx n regards
No activity results to display
Leave a comment: