Hello Friends,
I have an eVB app which scans the barcode. While loading the app I initialize the Access database (.CDB) connection and the connection name is
oConnection
After barcodes scans complete I take out the item number from barcode scanned string.
I use that item number to look into...
Hello Friends,
I have an eVB app which scans the barcode. While loading the app I initialize the Access database (.CDB) connection and the connection name is
oConnection
After barcodes scans complete I take out the item number from barcode scanned string.
I use that item number to look into...
There are two tables sitting on different oracle database. But their names are same called HEADERS. First database's name is CTR and second is CRP. The HEADER table of database CRP is a copy of table from HEADER@CTR. There are 9 primary keys in both the tables as they both are having same...
You might have to write program itself in Clipper first. Do this.
Create a flat file specially for MEMO text using your .DBF file which also has .DBV file. Use the primary key from .DBF (e.g. Invoice#,,etc.). Go record by record using DO WHILE !EOF()..ENDDO. You should create the flat file...
I have two same table names on different oracle databases (different servers also). Database1 has master table called HEADERS and Database2 has also table name called HEADERS. We are updating Database2.HEADERS using the Database1.HEADERS every night. It works fine but few records are missing...
Can anybody give me answer on this ?
I have two same table names on different oracle databases (different servers also). Database1 has master table called HEADERS and Database2 has also table name called HEADERS. We are updating Database2.HEADERS using the Database1.HEADERS every night. It...
Thanks for your help Sem, But it doesn't seems to be working. I'm including the code below. Try to run.
Thanks again.
Nikhil Shah
create or replace package tst_vars as
test_cond boolean;
end;
/
create or replace procedure tst_chkval AS
mcondition varchar2(500);
Cursor test_cur IS...
Hello,
I wrote big pl/sql script containing 19 cursors. Well it works very fine & its been in production since long time.
Now I have come some changes in that and those changes are not permanent. I may have to change again & recompile the script again. In these changes I'm putting one line...
assume that your text file is mytest.txt located on C:
Dim nLine as Long
Dim Linedata As Variant
Open "c:\mytest.txt" For Input As #1
nLine = 0
Do While Not EOF(1)
nLine = nLine + 1
Line Input #1, Linedata
Loop
nLine = nLine + 1
MsgBox "Total line is " & Str(nLine)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.