Re: Using Design View versus SQL Statement View

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John F <John F> wrote in
news:7386B4F9-6466-4616-92AE-A7C8FC22B5FB@xxxxxxxxxxxxx:

Do most Access professional developers maintain SQL source in
external files?

WHy would anyone do that?

Mostly, I don't give a rat's ass how the SQL is formatted, because I
let the QBE write the SQL.

The only exception to that is on-the-fly SQL I construct in VBA
routines. In that case, the query designer is not involved, so the
format I specify remains intact.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: FAQ Topic - How do I format a date with javascript? (2009-06-01)
    ... Maybe I can get a little more insight from John G Harris. ... This is what ISO/IEC 9075-2:2003, the SQL standard, says. ... This is a human input format. ...
    (comp.lang.javascript)
  • Re: Changing the date
    ... As part of the sql ... You can use the CONVERT function to change a datetime datatype in to a string representation with a certain format. ... John ...
    (microsoft.public.sqlserver.server)
  • MSProject
    ... Could I ask a favour and ask if you could update this to a new format of msproject? ... You could look at saving as an Excel file from Project 95 and then opening ... Project MVP ... I also received a reply from John, ...
    (microsoft.public.project)
  • Re: Inserting regional settings specific data into sql server
    ... All EU countries withouth the two English speaking use the format dd-MM-yy ... By using the parameters, while the program is in the right culture setting, ... than all those formats results using SQLparameters in the way the SQL server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Inserting regional settings specific data into sql server
    ... Italianyou will observe that the settings used are 10/02/2006 ... it a better idea to Format it using the string format functions or a very ... into the sql database.Sorry to bug the shorts off you but u now have context ... By using the parameters, while the program is in the right culture setting, ...
    (microsoft.public.dotnet.framework.adonet)