Re: INSERT command doesn't work in Access

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



"Rogas69" <rogas69@xxxxxxxxxxxxxxxx> wrote in
news:OPotf$lcFHA.1356@xxxxxxxxxxxxxxxxxxxx:
> The reason I am using this is rather to allow quick assessment of
> meaning of fields in complex query at design time not at run time. Why

Yes, I understand why you are using it. But its very non standard.

You are likely using it becuase your "tools" are not typesafe. ie DataReaders etc. But if you use
something like Indy.Data or LLBLGEN then your data access becomes typesafe, so type
mismatches are not possible. If this is the case, then you are using it to help fulfill a short
coming in your tools.

> should I not use it? It is one of best methods IMO to avoid mistakes.

Its better to used typed access and not just help to avoid, but eliminate instead.

> One of reasons Microsoft advices against hungarian notation now (yet
> 3-5 years ago it was completely different) is that tools can show you
> the type of a member variable. Yes they can. But what if you view the
> code on a web page, or in notepad? And if you are reading the code you

Why would I use notepad for any real development?

> But, once again, it is a matter of convention.

As I said, if you are the only one use a database its merely a personal preference. However if
others are using your database as well, you will receive a lot of negative feedback regarding this.


--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Blog: http://blogs.atozed.com/kudzu
.



Relevant Pages

  • compiler and metadata, request opinions...
    ... a lot of the upper/middle compiler machinery is still lacking (such as ... embed the metadata directly into the object modules (the reason being that ... request for a particular piece of information is embedded in a symbol (sort ... it will be loaded into an in-memory version of the database. ...
    (comp.compilers)
  • misc: compiler and metadata...
    ... a lot of the upper/middle compiler machinery is still lacking (such as ... embed the metadata directly into the object modules (the reason being that ... request for a particular piece of information is embedded in a symbol (sort ... it will be loaded into an in-memory version of the database. ...
    (comp.lang.misc)
  • Re: text file saved in COM format..
    ... you obviously either never used the internet, ... caused it to run rather than opening in notepad. ... one possible reason is that a user writing a batch file may not ... windows xp by default, hides extensions, the last 3. ...
    (microsoft.public.windowsxp.general)
  • RE: how to list LE options
    ... for whatever reason an applications programmer has to look at this ... curiousity and desire to expand their knowledge, there is no real reason ... LE options were copied to an application parmlib, ... There's no reason that Database, CICS and other groups can't maintain ...
    (bit.listserv.ibm-main)
  • RE: [dbi] RE: Accessing MS Access through the DBI ODBC
    ... reason for this issue is the mdb is on a mapped drive where the mapped driver ... > still getting 'Unable to connect to database'. ... > use DBI; ... Then it will simply display it and die since there ...
    (perl.dbi.users)