Matthew Jarvis wrote:
> Vince Teachout wrote:
> <snip>
>
>> No, but the "God, this is boring - I wonder if I can automate this"
>> function "MSSqlMe() I wrote about 4 years ago to rewrite VFP tables into
>> MSSql tables is certainly coming in handy! :-D
>>
>>
>
> Vince-
>
> That sounds like it could be handy - care to post the code?
I've been thinking about posting my ME() functions for some time:
SqlMe() - creates a SQL Select statement in the clipboard for the
current WA, with several options
InsertMe() - Creates a Insert statement in the clipboard, with several
options, and also creates the VALUES clause with a leading character
that indicates what kind of data is expected. Plus, bonus, it sounds
naughty.
CurseMe() - creates a FILE containing a CREATE CURSOR statement for
current WA, with lots of options
MySQLMe() - Creates a MySQL CREATE TABLE statement, etc...
MSSQLME() - Creates a MS SQL CREATE TABLE statement, and IIRC, creates
the ALTER Table command for the Primary index, and the index commands
for the other indexes
MyAccessMe() - ditto for Access
ORASQLME() - ditto for Oracle
OraDate() converts a vfp date to Oracle TO_Date command for use in
queries: e.g. OraDate(date()) =" To_Date('12/14/2006','MM/DD/YYYY')"
NvlSQLMe() - creates a SQL Select statement in clipboard with all fields
NVL'd: SELECT NVL(Spons_uid, '') AS Spons_uid... etc...
WaitGlass() - turns hourglass cursor on/off
These things save me hours of time doing repetitive, boring coding. If
there's any interest, let me know and I'll e-mail code to whoever wants
it. If people STILL think it's useful after getting and trying the code,
let me know and I'll talk to Ed about putting it in the downloads section.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
