Search results

Hi, I need one program to load the data from excel to different progress table. Example: define temp-table tt_table fields tt_fields as char extent 15 fields tt_rec_no as integer. update m_load_table. /* m_load_table - might be customer or supplier ( or any other table name ) it is a input...

Is there any way to update the statement should accept only nagative value? Example Define variable a as decimal format "-9999.99" no-undo. update a. This will accept both +ve & -ve numbers. My question is should accept only -ve.

Hi, Currently we are going to use the bar code in the QAD. We have one screen to capture the bar code information and same screen user can manually enter the data also. Is there any way to differenciate the bar code information and manually entered information? Please provide the solution...

i need more the one print out for a particular printer. Is there any way ?

When i am using this printer for korea, i am unable to get the desired output that means format is wrong. Can anyone tell me what i need enter in the below fields in 36.13.2? Initialize Command: Initialize Ctrl: 80 Column Start: 132 Column Start: Reset Ctrl: Reset Command:

Is there any diagrammatic explaination for Purchase and Sales Cycle upto the General Ledger Impact? i want the step by step action. Kindly help anyone.

Is there any material about the Admin DB tables? Purpose of the table and when those tables are used in standard eb2 codes.

Can anyone tell me the step by step procedure for Field help and Procedure help?

My input is table name : customer Output is dump of the customer. Condition: Don't create the .p program dynamically.

In the report option: page result comes 07070000-00-0209 In the report output : printername result comes 07070000ù00ù0209 Except that - remaining all are printing correctly. Can anyone tell me the solution.

How can i freeze and unfreeze the table in incremental DF?

I want to know about the Full Purchase Cycle. Can you provide any material for that?

I want to change the Logical DB name, Using the progress coding. My LDBNAME = ganeshdb, but i need sureshdb.

How can i find out the exact DB Size? I used promon <dbname> then activities Result: DB Size 1352 MB BI Size 2168 K AI Size 0 K (Is it correct size?) 1. What is DB Szie and BI Size AI Size? 2. When some one asks me what is the size of the particular DB? How can i find out?

Database Automatically shutdown the db and i checked the .lg file, I saw the below two line 22:16:19 BROKER 0: SIGTERM received. (3694) 22:16:51 BROKER 0: Begin normal shutdown (2248) 22:17:00 BROKER : Removed shared memory with segment_id: 50889071 22:17:00 BROKER : Removed shared memory...

My Physical Db Name : ganeshdb Logical Db Name : ganesh .r logical Db Name stamping : qaddb How it is working?

I want to know about 1. _file 2. _sequence 3. Is there any other tables are start with _. 4. Codes for list the table's field name, Label Name & format

i need the sql query and progress coding for display all the field except one filed. Ex: table name emp fields :e-no,e_name,e_ad1,e_ad2,e_ph ,etc Select * , with out e_ad2 from emp;

How can i get the sequence current value without creating the program dynamically and my input is database name. Input : Db Name : sports.db Expected output : sequence name , sequence current value

for the below code i want to display the table instead of deleting the record. DEFINE VARIABLE a AS CHARACTER NO-UNDO. UPDATE a run DeleteThisTable (a). PROCEDURE DeleteThisTable : DEFINE INPUT PARAMETER ipcTableName AS CHARACTER NO-UNDO. DEFINE VARIABLE hBufferHandle AS HANDLE NO-UNDO...