When using a picklist for a table field that references another table, the list of entries shows in the picklist, but when an entry is selected and I attempt to move to another field the following error appears:

exception class 'EDatabaseError" with message:
"Canon" is not a valid integer.

I understand that the entry should actually be an integer. How can I display the selection, but capture the integer of the referenced table?

bob k.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20080629/486e14e3/attachment.html

Anybody? Please...

--- El jue 3-jul-08, Bob K. escribi?:

Can you please submit a bug report with a sample project, for db samples of preference please use tdbf or firebird (please supply sql script to create and populate db in this case, or db backup)

Jesus Reyes A.

__________________________________________________ Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ?gratis! Reg?strate ya - http://correo.yahoo.com.mx/

Use RxDBGrid for such lookups. Svn version is preferable http://wiki.lazarus.freepascal.org/RXfpc

Will do.

--------------------------------------------------

Denis,

I'm having the same problem with RxDBGrid. Are you not having this problem?

bob k.

--------------------------------------------------

Use KeyList/PickList properties, and fill them on form show (or create). Something like the following^

procedure TfrmOrderGoods.DealerPickListFill;
var SQL:TSqlite3Dataset;
    C:TRxColumn;
begin
  C:=grdBusket.ColumnByFieldName('Dealer');
  C.KeyList.Clear;
  C.PickList.Clear;
  SQL:=nil;
  try
    SQL:=BaseConnect.DatasetCreate('select d.id, d.Name from Dealers d order by d.Name');
    while not SQL.EOF do
      begin
	C.KeyList.Add( SQL.FieldByName('id').AsString );
	C.PickList.Add( SQL.FieldByName('Name').AsString );
	SQL.Next;
      end;
  finally
     SQL.Free;
 end;
end;

Denis,

The keylist is not available. I can see it as a property in the columns, but I'm unable to access it:

      with RxDBGridCamera do
        begin
          Visible:=True;
          Columns[0].Visible:=False;
          Columns[1].PickList:=List;
          Columns[1].KeyList:=List;
        end;
rakphoto.pas(115,22) Error: identifier idents no member "KeyList"

--------------------------------------------------

Are sure your Columns[1] is of type TRxColumn? TRxColumn definitely contains KeyList (just checked).

TRxDbGrid also has
property Columns: TRxDbGridColumns

The KeyList shows up at design time when I select a Columns property. Is there a way I can tell which type of column it is?

bob k.

--------------------------------------------------

Bob K. wrote

The KeyList shows up at design time when I select a Columns property. Is there a way I can tell which type of column it is? bob k.

Well, Columns.ClassName will return its class as string. Or simply Ctrl+click Columns identifier.

It's TRxDbGridColumns. Why is it different from yours? And is there something I can do about it?

bob k.

--------------------------------------------------

Use svn version. I must work right

I'm not sure what you mean by svn version. Lazarus? RxDBGrid?

bob k.

--------------------------------------------------

Bob K. wrote

I'm not sure what you mean by svn version. Lazarus? RxDBGrid? bob k.

Get RxDBGrid svn version (RxFpc - full name)

Denis,

Do you have the link?

bob k.

--------------------------------------------------

Use
svn co https://lazarus-ccr.svn.sourceforge.net/svnroot/lazarus-ccr/components/rx

P.S. Google banned you? :)

I've searched several different sites that I just wanted to be sure I went to the correct one... I don't think Google has banned me... yet :)

So each of these files should be saved in the appropriate RxFpc folder? And then reinstall the components?

bob k.

--------------------------------------------------

Exactly.

Denis,

Thank you for your help.

bob k.

--------------------------------------------------

Hi Denis,

I finally had a chance to re-install rxfpc (was on holiday), and the columns are still RxDbGridColumns, so the PickList property is not available. Help!!!

thanks,
bob k.

--------------------------------------------------

Anyone???

--------------------------------------------------

Denis,

Is there any way to get the PickList into the RxDBGridColumns. I've attempted to change the columns from RxDBGridColumns to RxColumns but without any luck.

bob k.

--------------------------------------------------