bBrowser- why can't I append?
in [Visual Objects]
|
Prev: CellDoubleClick()
Next: app crashes...
From: Kevin on 12 Jun 2010 02:50 Bill, In your code where you open the database table to Append,try leaving out the AutoIncrement column and just open the others. Then append a row and see if that works. As far as I understand the AutoIncrement should still work, you just won't see it in VO. Use a copy of the database file rather than the production one, obviously. Hope this helps. Kevin "Bill Tillick" <wtillick(a)gmail.com> wrote in message news:16068797-be75-481f-99b1-696d0e8029f3(a)6g2000prg.googlegroups.com: > Next episode in the saga..... > > 1. I have used Access 2007 on another computer to access my .mdb > database. No problems experienced. Added new record OK. > > 2. I have modified my simple test program, firstly by removing the > bBrowser control. Then I tested with 2 other tables in the database, > one of which has only 3 columns - a numeric ID and 2 text fields. > Each crashed with exactly the same error as previously on the > server:append()! > > It seems to me that the only common factor between the 3 tables is > that I have an autoincrement ID field?? I wonder if VO2.8 has a > problem with this? > > Regards, > Bill
From: Bill Tillick on 12 Jun 2010 18:36 Kevin, Did that, same error. Thanks, Bill
From: Bill Tillick on 13 Jun 2010 17:48 Kevin, I found the fault with that simple example - when I removed the bBrowser I didn't specify the SQLProducts server for the window (it had previously been attached to the bBrowser. Sorry about that. I am now about to put a bBrowser back onto the window. Regards, Bill
From: Bill Tillick on 15 Jun 2010 02:10 Kevin, I put a bBrowser control onto the window, nothing else. Now the program is crashing again with that same persistent error! Does this imply some conflict between VO2.8 and bBrowser3? i.e. the simple window without bBrowser accepts an append(), whereas adding a bBrowser causes the program to crash. Thanks, Bill On Jun 14, 9:48 am, Bill Tillick <wtill...(a)gmail.com> wrote: > Kevin, > I found the fault with that simple example - when I removed the > bBrowser I didn't specify the SQLProducts server for the window (it > had previously been attached to the bBrowser. > Sorry about that. > I am now about to put a bBrowser back onto the window. > Regards, > Bill
From: Kevin on 15 Jun 2010 07:35
Bill, I would not say it is between VO28 and bBrowser 3 unless it is down to the SQL object you are using. This is based on the fact that I have not encountered any problems there. I don't append in a bBrowser window but use a different window and then refresh the server object. I am also using VO2ADO for browsing the SQL tables rather than the VO SQL tables. To test if it is a VO - bBrowser problem set a DBF file and bBrowser for it. Then try to append to the DBF. Hope this helps. Kevin7 "Bill Tillick" <wtillick(a)gmail.com> wrote in message news:89602895-5c0f-49d5-8821-0cb40d5b4757(a)23g2000pre.googlegroups.com: > Kevin, > I put a bBrowser control onto the window, nothing else. > Now the program is crashing again with that same persistent error! > > Does this imply some conflict between VO2.8 and bBrowser3? > i.e. the simple window without bBrowser accepts an append(), whereas > adding a bBrowser causes the program to crash. > > Thanks, > Bill > > > On Jun 14, 9:48�am, Bill Tillick <wtill...(a)gmail.com> wrote: > > Kevin, > > I found the fault with that simple example - when I removed the > > bBrowser I didn't specify the SQLProducts server for the window (it > > had previously been attached to the bBrowser. > > Sorry about that. > > I am now about to put a bBrowser back onto the window. > > Regards, > > Bill |