PC Review


Reply
Thread Tools Rate Thread

Adding a New record to SQLCE

 
 
Jeff
Guest
Posts: n/a
 
      27th Feb 2004
I have a SQLCE table with a GUID for a primary key. I understand (I
think) that, when adding a new record, I don't specify the primary key
value. But how do I then retrieve the primary key value for the
just-added record? (I'm using vb.net)

Thanks for your help.

- Jeff
 
Reply With Quote
 
 
 
 
Chris Tacke, eMVP
Guest
Posts: n/a
 
      27th Feb 2004
No, you will have to specify the PK value. Identity would mean you don't
have to (it's basically an autonumber).

--
Chris Tacke, eMVP
Co-Founder and Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net


"Jeff" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a SQLCE table with a GUID for a primary key. I understand (I
> think) that, when adding a new record, I don't specify the primary key
> value. But how do I then retrieve the primary key value for the
> just-added record? (I'm using vb.net)
>
> Thanks for your help.
>
> - Jeff



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fastest way to check if a record exists in SQLCE using ADO.NET =?Utf-8?B?U2ltb24gSGFydA==?= Microsoft Dot NET Compact Framework 0 2nd Nov 2005 02:09 PM
Delete record in sqlce =?Utf-8?B?d3lnaGY=?= Microsoft Dot NET Compact Framework 3 22nd May 2005 09:55 AM
SqlCe Insert Record Performance =?Utf-8?B?d3lnaGY=?= Microsoft Dot NET Compact Framework 16 20th May 2005 07:27 PM
SqlCE Deletion of record from DataSet Chris Voon Microsoft Dot NET Compact Framework 3 17th Dec 2003 01:42 AM
insert sqlce record with rapi ? efrat Microsoft Dot NET Compact Framework 1 10th Aug 2003 06:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:04 AM.