Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wierd DBF name
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00407919
Message ID:
00407957
Vues:
24
>I have some code that looks like this
>
>
>dStartDate={08/17/2000}
>dEndDate={08/17/2000}
>
>SELECT ach.settdate, ach.bankname, ach.portfolio, ;
> COUNT(ach.mid) AS tot_ach ;
> FROM ach ;
> WHERE BETWEEN(ach.settdate, m.dStartDate, m.dEndDate) ;
> GROUP BY ach.bankname ;
> INTO cursor achjunk2
>
> sele achjunk2
> brow
>
>When I look in BROWSE the cursor, the name of the cursor is wrong. It says BANK. This happens whenever I run cursors instead of tables. I then get this in both situations after this. I have to exit VFP and restart to get rid of it. I do have a BANK.DBF in a database where ACH.DBF lives. Ever seen this before? How do I get it to stop?
>
>Thanks in advance.

Sorry for irrelevant point, but why do you need to repeat ach, if you're selecting only from one table? I'd get rid off all this 'ach' at all. Also I would specify database name, e.g. from MyDBC!ach. You also don't need to select achjunk2 after your select statement (this cursor should be selected by default), though it's harmless. These are just thoughts, sorry for not able to help with your particular question.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform