VB & Database, How? insert data with SQL Insert statement

How? insert data with SQL Insert statement

Author	Message
Steve Barnet #1 / 4	How? insert data with SQL Insert statement I've fallen over a potential problem. So far my app uses SQL statements to do all record insertion and updating of data, but I now find that I need to store large amounts of text. I've added a "longtext" field to my database table, but when I came to code the INSERT INTO statement, I found that I did not know how to code it! Assuming that the data I want to store is large-ish (say 200K of RTF text), how do I code the INSERT statement... Can I just treat it like a very long string of text an put quotes around it, or is there some restriction on the amount of data going through an INSERT statement? Similarly, if this was binary data, how would I go about inserting it into a database? I may be worrying without reason, but would appreciate some reassurance. Thanks Steve
Sat, 03 Aug 2002 03:00:00 GMT

A. Joha #2 / 4	How? insert data with SQL Insert statement Steve what database are you using access? Quote: > I've fallen over a potential problem. So far my app uses SQL statements to > do all record insertion and updating of data, but I now find that I need to > store large amounts of text. I've added a "longtext" field to my database > table, but when I came to code the INSERT INTO statement, I found that I did > not know how to code it! > Assuming that the data I want to store is large-ish (say 200K of RTF text), > how do I code the INSERT statement... Can I just treat it like a very long > string of text an put quotes around it, or is there some restriction on the > amount of data going through an INSERT statement? Similarly, if this was > binary data, how would I go about inserting it into a database? > I may be worrying without reason, but would appreciate some reassurance. > Thanks > Steve
Sat, 03 Aug 2002 03:00:00 GMT

Steve Barnet #3 / 4	How? insert data with SQL Insert statement I'm using DAO 3.6 to an Access MDB file. Steve Quote: > Steve what database are you using access? > > I've fallen over a potential problem. So far my app uses SQL statements to > > do all record insertion and updating of data, but I now find that I need > to > > store large amounts of text. I've added a "longtext" field to my database > > table, but when I came to code the INSERT INTO statement, I found that I > did > > not know how to code it! > > Assuming that the data I want to store is large-ish (say 200K of RTF > text), > > how do I code the INSERT statement... Can I just treat it like a very long > > string of text an put quotes around it, or is there some restriction on > the > > amount of data going through an INSERT statement? Similarly, if this was > > binary data, how would I go about inserting it into a database? > > I may be worrying without reason, but would appreciate some reassurance. > > Thanks > > Steve
Sat, 03 Aug 2002 03:00:00 GMT

Shawn M. Hoope #4 / 4	How? insert data with SQL Insert statement Steve, The only trick I've heard about this one so far is that you have to place are your longtext fields as the last fields in your insert statement. Quote: > I've fallen over a potential problem. So far my app uses SQL statements to > do all record insertion and updating of data, but I now find that I need to > store large amounts of text. I've added a "longtext" field to my database > table, but when I came to code the INSERT INTO statement, I found that I did > not know how to code it! > Assuming that the data I want to store is large-ish (say 200K of RTF text), > how do I code the INSERT statement... Can I just treat it like a very long > string of text an put quotes around it, or is there some restriction on the > amount of data going through an INSERT statement? Similarly, if this was > binary data, how would I go about inserting it into a database? > I may be worrying without reason, but would appreciate some reassurance. > Thanks > Steve
Mon, 05 Aug 2002 03:00:00 GMT

Page 1 of 1

[ 4 post ]