It does sound like your string is too long. Build it up in parts, not all
of it can be between one set of quotation marks. Maximum between quotes is
255 chars.
m.cSQL = [insert into food ]+;
[(FoodID,CategoryID,CompanyID,]+;
[UserID,Name)]+;
[ values ]+;
[(?lnFoodId,?lnCategoryId,?lnCompanyId,]+;
[?lnUserId,?lcName)
Fred
On Thu, Apr 12, 2012 at 9:43 PM, Michael Oke, II <[email protected]> wrote:
> Not tonight. It's at the office and, fortunately, I am not. It's roughly
> 26 fields, mostly numeric.
>
>
> Michael Oke, II
> 661-349-6221
>
> Contents of this and all messages are intended for their designated
> recipient.
>
> On Apr 12, 2012, at 8:51 PM, Stephen Russell <[email protected]>
> wrote:
>
> > On Thu, Apr 12, 2012 at 10:33 PM, Michael Oke, II <[email protected]>
> wrote:
> >> Although you might think so, it is not. There is another field,
> FoodKey, that is auto-incrementing. In this case, lnFoodId has a value of 0.
> > -----------------
> >
> > great. Now can you give us the entire string?
> >
> >>
> >>
> >> Michael Oke, II
> >> 661-349-6221
> >>
> >> Contents of this and all messages are intended for their designated
> recipient.
> >>
> >> On Apr 12, 2012, at 8:11 PM, Stephen Russell <[email protected]>
> wrote:
> >>
> >>> On Thu, Apr 12, 2012 at 6:50 PM, Michael Oke, II <[email protected]>
> wrote:
> >>>> "insert into food (FoodID,CategoryID,CompanyID,UserID,Name) values
> (?lnFoodId,?lnCategoryId,?lnCompanyId,?lnUserId,?lcName)
> >>>>
> >>>> String is longer but that gives you the basics.
> >>> ---------------
> >>>
> >>> Came to the party late.
> >>>
> >>> how are you generating ?lnFoodId, That is a primary key I believe..
> >>>
> >>>
> >>> --
> >>> Stephen Russell
> >>>
> >>> 901.246-0159 cell
> >>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAJCBksrS3c8gYhM8AXcK+J+xEwA=ndf4gf0s8v_2rxtkmtf...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
