Delphi For PHP Forums       


Go Back   Delphi-PHP Forums > Delphi4PHP NNTP Newsgroups > embarcadero.public.delphiphp.vclforphp.components.using
Forum Jump Register FAQ Members List Downloads Search Today's Posts Mark Forums Read

embarcadero.public.delphiphp.vclforphp.components.using This group is for all discussion about the use of VCL for PHP components.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 9th July 2007, 00:09
GR
Guest
 
Posts: n/a
Default dbgrid saving data after edit

Hi!

I build a small application using a dbgrid, query, database and datasource
components.

The data is showed in the grid and I can edit values on each row, but the
data was not saved to database.

I put in the form a button with the code below in onclick event:
function Button1Click($sender, $params)
{
$this->Query1->Post();
}
But when I click in this button I receive the messages:
Warning: reset() [function.reset]: Passed variable is not an array or object
in C:\program files\CodeGear\delphi for php\1.0\vcl\dbtables.inc.php on line
815

Warning: Variable passed to each() is not an array or object in C:\program
files\CodeGear\delphi for php\1.0\vcl\dbtables.inc.php on line 816

Application raised an exception class ADODB_Exception with message 'mysql
error: [1064: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'WHERE LIMIT 1' at line 1] in EXECUTE("SELECT * FROM WHERE LIMIT 1")'
Callstack #0 File: C:\tmp\dbgridtest\unit1.php Line: 48
....Other problem: I see only a fixed number of records. How to se more
records on a dbgrid object?Thanks!GR


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 30th January 2010, 15:29
D4PHP User
 
Join Date: Jan 2010
Posts: 64
mhmda is on a distinguished road
Default

I got this error too, I tried every think but nothing, Have you solve it !!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 3rd February 2010, 10:52
D4PHP User
 
Join Date: Jan 2010
Posts: 64
mhmda is on a distinguished road
Default

use sql "insert" or "update"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 16:32.




Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 ©2009, Crawlability, Inc.
Copyright © 2004 - 2009, G&J Solutions Ltd. All Rights Reserved. terms of use