From: | John Steely <davinciwizard(at)home(dot)com> |
---|---|
To: | pgsql-questions(at)postgreSQL(dot)org |
Subject: | Re: How do I "Insert" using a type member? |
Date: | 1999-03-27 04:34:13 |
Message-ID: | 36FC6074.B15AF038@home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ty,
You were on the right track. I'm assuming this is a string in your VB
app; if so, just quote the rest of the strings:
SQL = "Insert SoftwarePackage(Name,Path,Size,nFiles) " _
& "value ('" & sw.cName & "', '" _
& sw.cPath & "', '" _
& sw.sSize & "', '" _
& sw.hFiles & "')"
Just make sure Size and nFiles are char/varchar fields.
HTH
John Steely
DaVinci TWG
Ty Augustine wrote:
>
> Hi,
> I'm a newbie to VB and SQL. I have VB6 and SQL7. I'm trying to insert
> Strings that are members of a type into SQL, This is what i've tried with
> no success. How do you do this? and how would I do this using a stored
> procedure?
>
> 'SQL = "Insert SoftwarePackage(Name,Path,Size,nFiles) " _
> ' & "Values('" & sw.cName & "'," _
> ' & sw.cPath & "," _
> ' & sw.sSize & "," _
> ' & sw.hFiles & ")"
From | Date | Subject | |
---|---|---|---|
Next Message | Richi Plana | 1999-03-27 04:41:48 | Determining if "in a text set" |
Previous Message | Lynn Gabbay | 1999-03-27 02:54:06 | is there a 'byte' type? |