1. My "Order_items" file had over 500000 records.
Now i want to make a temporary file, it's about the Order no. "12345" (there have 5 items only)
I will coding as below :
SELE ORDER_ITEMS
SEEK ORDER_FILE->ORDER_NO
COPY TO TEMP_FILE WHILE ORDER_NO == ORDER_FILE->ORDER_NO
USE TEMP_FILE IN 0 EXCL
SELE TEMP_FILE
Now i want to write in SQL ways, how to do ?? And i want to know, is't SQL must be faster then "SEEK + COPY TO (WHILE...)"
2. How to add more fields into existing file.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement