OpenEuphoria

Re: euEDB / euSQL primary key problem

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Feb 18, 2007
• 512 views

duke normandin wrote:
> 
> Thanks for clueing me in, Matt. I haven't gotten into *any* Euphoria /euSQL
> coding yet. I'm just fooling around with your "edb" widget. Very cool! Good
> way to brush up on my SQL as well! 
> 
> So, as I'm writing this, I'm also looking at the "table definition" tab for my
> "Participants" table. Am I correct in assuming that all I have to do is rename
> ID => PK.ID  and ACTIVITY => PK.ACTIVITY  _and_ click the Primary Key box
> for both? I'll try it at any rate, but I thought that I'd ask while I was 
> thanking
> you for your reply. L8r...

Actually, the primary key is determined by whatever the first listed field
is.  The check mark is more to communicate to you what the primary key is.
So you'd have to move them (or at least one of them) to the top of the
list.  

Matt