Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
In GETFILE need default Filename
Message
De
14/01/2015 07:18:36
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01613339
Message ID:
01613590
Vues:
61
>Anyway to get a default FileName already typed in for this user so he doesn't have to pick one if he would just like to select the default one I gave? (like LOCFILE does)? I can't use LOCFILE as that will pick the file if in fact it does exist.
>
>Thanks in advance.....
>
>Mel

Hi,
when our users generate their own reports (based on our default versions) they can define any name they want. period.
However....
any unwanted character found in the filename will be replaced by blank within textbox valid event.


This.Value = ALLTRIM( CHRTRAN( This.Value , [!"§$%&/()=?\*+'#-.:,;|] , [ ] ) )


Additionally, that name isn't used as identifier as it will only be a part of the real filename.
In case the users reportname input is "my 1. reporttest & so on" it will be converted to "my 1 reporttest so on".
After that, a unique ID is created by a stored procedure (GetNextReportID) within the DB and stored in a ID table.

This ID is used in the filename -> i.e. "001234_my 1 reporttest so on.frx|frt"

The generated reportname is stored in a table thats used for report selections. This way users don't get access to the file directly.
To be honest, the users filename definition doesn't even have to be part of the real filename at all. It simply helps our supporters to identify reports.
Best Regards
-Tom

Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.

Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform