Re: Setting primary key in Visual Basic

From: Niki Estner (niki.estner_at_cube.net)
Date: 01/25/04 

Date: Sun, 25 Jan 2004 18:06:02 +0100

"Old Enough to Know Better" <SpamSucks@NoSpam.com> schrieb im Newsbeitrag
news:Tr%Pb.45273$f97.3270@fe3.columbus.rr.com...
>
> "KLinZ" <klinz@NOSPAMMERTSzenobits.com> wrote in message
> news:bup120$7iu$1@hermes.castel.nl...
> > Edward wrote:
> > > Im trying to make a prgram which will list some BMXs that i am
> > > selling, and I want to be able to modify records already stored in
> > > the text file. I can add new files, but am unable to overwrite, and a
> > > new product with the same ID can always be added. How can i make the
> > > product id unique so that if another product with the same id is
> > > added, it will overwirte the previous version? A snippet of code would
> > > be handy.....
> >
> > General solution: use UPDATE instead of INSERT.
> >
> > Some more info about the database system you are using would be handy.
> >
>
> Are you using a text file, access or SQL ?
> It would appear that you are using a plain text file.

These aren't alternatives.
Text/Access files are ways to store data; SQL is a language for queries on
that data.
You can't store data in 'SQL'. You can access some data storage (like
SQL-Server, Access, text files) using SQL (via ODBC/OLEDB/ADO).

> > --
> > www.zenobits.com
>
>

Niki

Relevant Pages

  • Re: TS disaster recovery / split site scenario
    ... The only thing I would say is that, with TS, usually you do not store data ... but instead use file servers to store data. ... They have multiple servers running the usual stuff - exchange / sql etc. ...
    (microsoft.public.windows.terminal_services)
  • Re: Database options for CE 4.1
    ... Use SQL CE 2000. ... > I have a windows CE application that now needs to store data on the ... > heard about windows SQL 2000 CE but can't find anywhere to download it ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: connection to database(mysql)
    ... > i want to retrieve and store data to database through matlab> so how can i connect ??? ... I use MS SQL so the details can differ. ...
    (comp.soft-sys.matlab)
  • Re: Using Bitmasks and FlagFields in SQL
    ... Bitmaps are a very poor way to store data in SQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: Using Bitmasks and FlagFields in SQL
    ... Bitmaps are a very poor way to store data in SQL. ...
    (microsoft.public.sqlserver.programming)