Lookup fields do not return data.

[BigChimp]

You perhaps only built a debug ide? The bufdataset unit is fpc so that won't be included in a debug build.
You'll need to run something like make --OPT="-gw -gl" (not sure of exact option name etc)

... or using fpcup to get a debug everything build for Laz SVN, with FPC fixes 2.6.1:

fpcup --fpcopt="-gw -gl" --lazopt="-gw -gl"

Make sure you have nothing in c:\development and that you have write permissions there. However, it will happily exist side-by-side with existing Lazarus/FPC installs

[taazz]

ok, ok, downloaded fcup created the directory C:\developing I just copy it there and run it?

I already have turtoisesvn installed is there something I should know before sarting the process?

My main idea is use svn version for bugs/enhancements lazarus/fpc specific tasks and keep a clean release installation too for my current projects.

[BigChimp]

c:\development
unless you want to fiddle around with options (see fpcup --help)
Yes, just put it there.

It's best if tortoisesvn's directory with svn.exe is in your path.
Otherwise no problem, it will download its own svn.exe but you won't get the SVN revision number in your Lazarus/About screen, which can be handy.

Good idea to keep 2 separate installs. That's the way I use it too.

[ludob]

Had a look at the sample program and the KeyFields and LookupKeyFields are mixed up. Here is the part of the lfm file relative to StringField1 that is changed. Works with laz 1.1 fpc 2.7.1.

Code: [Select]

    object StringField1: TStringField
      DisplayWidth = 45
      FieldKind = fkLookup
      FieldName = 'title'
      Index = 3
      KeyFields = 'fktitleid'
      LookupCache = True
      LookupDataSet = titleQuery
      LookupKeyFields = 'titleid'
      LookupResultField = 'title'
      ProviderFlags = [pfInUpdate, pfInWhere]
      ReadOnly = False
      Required = False
      Size = 45
    end


[codifies]

I've already tried that way round as mentioned the example posted is the result of trying multiple combinations of possibilities and is in a known to be incorrect state

(notice the screen shot of the dialog I posted shows the same settings you suggest...)

trying your settings when making the query active I see a dialog saying

peopleQuery : Field not found : "titleid"

which is no surprise being as titleid is in the titles table....

If you're saying you have the project working can you do a DIFF against the posted archive and tell us what else you have changed.

Its at least two of us are also seeing serious exceptions and IDE crashes, as well as confusing error messages

[taazz]

You perhaps only built a debug ide? The bufdataset unit is fpc so that won't be included in a debug build.
You'll need to run something like make --OPT="-gw -gl" (not sure of exact option name etc)

... or using fpcup to get a debug everything build for Laz SVN, with FPC fixes 2.6.1:

fpcup --fpcopt="-gw -gl" --lazopt="-gw -gl"

Make sure you have nothing in c:\development and that you have write permissions there. However, it will happily exist side-by-side with existing Lazarus/FPC installs

I S**T i didn't see your reply and started the download with out any options typed in. Should I stop and start over or it will rebuild from local data if I run it again?

[BigChimp]

No prob. Wait for it to finish, and run it again with the options. It will still take a while but as you've got the latest svn checkout, at least you won't get any (or many) updated files as it does svn update for both fpc+laz.

OT: I'd suggest laying off the coffee and switching to alcohol in order to increase the relaxation factor

[ludob]

Attached the project. I changed to TMysql50Connection since that is the client I'm using. That doesn't impact dblookup. The other thing I added is the FormOnCreate with the following 2 lines:

Code: [Select]

  titleQuery.Open;
  peopleQuery.Open;
The order of opening queries when streaming a form is undetermined (it is the order in the lfm but that can change when modifying a property). Here I force the order. The other way around gives an error message about an inactive dataset. I know, the auto opening of lookupdatasets is a mess. There are several bug reports about that and the maintainer has promised to get rid if that.

[codifies]

ah right at least there is a known issue with auto opening lookups ! I'm not going insane (it just feels like it!)

alas after trying the open commands in form create I'm seeing....

and its not just me is it, that error message *is* confusing!

[ludob]

Is that using the KeyFields and LookupKeyFields as I use them?

[codifies]

I think it is the connector I couldn't get the 5.0 connector to work ( ubuntu's libmysqlclient15off_5.0.96-0ubuntu3_amd64.deb package is from a distribution about a year and a half ago )

It only seemed to hang the compiled app when trying to use it

I changed to a 5.1 connector and changed the record names to lower case (are they really case sensitive now a days ! eek! )

and guess what I get exactly the *same* exception

I can only conclude that the issue is either with the 5.1 connector or the mysql driver itself

I'm going to try with postgress and see if I see the same issues....

[taazz]

No prob. Wait for it to finish, and run it again with the options. It will still take a while but as you've got the latest svn checkout, at least you won't get any (or many) updated files as it does svn update for both fpc+laz.

OT: I'd suggest laying off the coffee and switching to alcohol in order to increase the relaxation factor

Well I didn't got a chance to react after I posted that message laptop shutdown from heat.I just started over again its nice to know that it will continue and not do everything again.

Coffee?? I don't drink coffee I have it pluged as an IV, leaves my hands free for hair pooling.

[codifies]

damn - same error message with postgres too.....

[taazz]

After a day of building breaking installing uninstalling and generally instability of lazarus building process I think I have finally managed to make a breakthrough on the subject. I'm at a point where I can at least show an assembly based call stack and get a meaningful message out of this mess and the message leads to some the variants unit and some kind of conversion process failing.

I'm still trying to get fpc to compile with debug info so I can get a more meaningful call stack and see what is going on but I'm in a good path so far. I don't know this builting from source process gives me the creeps I'm uneasy all day long I'm never gonna get use to it. oh well, the battle must go on, back to my building process.

[codifies]

Stick with it!

I'm so desperate I'm considering booting windows for the first time in months to see if its any different there! 

For me evething works even an uncached lookup just doesn't show cell contents but does drop down and edit. Its only as soon as I enable look up cache

I'm seeing this with 64bit Laz 1.0 and 1.1 with fpc 2.6
on Ubuntu 12.04 using MySQL 5.1 connector or postgres connector....