Re: [libreoffice-users] Error messge interpretation...
Hi Michael, > > I "linked" the two fields for the subform and when I execute the form, I > get the error message: > > SQL Status: HY000 > Error code: 1 > > parameter marker count incorrect Could be you have written 2 fields for the mainform and one field for the subform? Other possibility: There are parameters in the query of the subform. You have more parameters than connected fields from mainform and subform. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Error messge interpretation...
Hi :) Is the relationship; 1 to 1 1 to many or many to 1 Or am i barking up the wrong tree - or just plain barking? Regards from a Tom :) On 17 July 2018 at 14:23, Michael Tiernan wrote: > I have a fairly simple form that queries a DB. > > I have a form and a subform. > > I "linked" the two fields for the subform and when I execute the form, I > get the error message: > > SQL Status: HY000 > Error code: 1 > > parameter marker count incorrect > > I assume it should be obvious but I can't figure out where the problem is. > > Anyone able to offer a breadcrumb for me to follow? > > Thanks for everyone's time. > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un > subscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Error messge interpretation...
I have a fairly simple form that queries a DB. I have a form and a subform. I "linked" the two fields for the subform and when I execute the form, I get the error message: SQL Status: HY000 Error code: 1 parameter marker count incorrect I assume it should be obvious but I can't figure out where the problem is. Anyone able to offer a breadcrumb for me to follow? Thanks for everyone's time. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy