Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
OpenRecordSet() and VFP 3.0 tables
I am using a VFP 3.0 free table. The following examples works fine when the field in the WHERE clause does not have a index tag on that field.
If the field in the WHERE clause does have a index tag, then the second command immediatley returns a 3219 invalid operation error message.
'********
Set db = OpenDatabase("d:\apps\web\data", _
False, False, _
"FoxPro 3.0")
Set l_tb = db.OpenRecordset("Select " _
& "pt_part, pt_desc, pt_product, pt_drawng " _
& "from depart where pt_part = '440' ", dbOpenSnapshot)
'********
Has anybody seen this before? I am using DAO 3.5. If I remove the index tag from the VFP table, then I can use the WHERE clause on any field. Otherwise, I can only use the where clause on non-index fields.
Thanks,
Jerryt
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