Search results for query: *

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...

how do I handle this ? What is the command to extend the segments TEMPORARILY ? thanks, nvshah

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...

you have to put all the columns in group by expressions if you are not using aggregate function on particular column Nikhil

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...

LOF(1) returns the size of the file not the total line numbers.

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)...