Hello,

Can you paste the code here so that I can take a look at it and perhaps see the problem?
Does your application have security on it?

-Ray

Hello,

Try the following code and let me know if it works for you.

If @Mode()=0 Then
{
	XLookup("data\pacific coast fruit products.db", vendor0, "contacts!ID#", "name_address0",vendor0)
} 

-Ray

I would like for you to run the following code and let me know the results. Place this in the same event as your current code.

	If FileExists("data\pacific coast fruit products.db") Then
	{
		Writeln("Path to file is correct")
	}
	Else
	{
		Writeln("Path to file is incorrect")
	}
	If @Len(@XListValues("data\pacific coast fruit products.db", "contacts!ID#")) > 0 Then
	{
		Writeln("Form Name and External Key correctly spelled")
	}
	Else
	{
		Writeln("Form Name or External Key spelled incorrectly, or DB file is locked")
	}
	If @Len(@XListValues("data\pacific coast fruit products.db", "contacts!name_address0")) > 0 Then
	{
		Writeln("Form Name and Source correctly spelled")
	}
	Else
	{
		Writeln("Form Name or source spelled incorrectly, or DB file is locked")
	}
 

-Ray

Hello debmckee,

Okay that all looks good. Go ahead and take that code out and try the following code.

Var vReturn as String

	If @Len(@XLookupAll("data\pacific coast fruit products.db", "..", "contacts!ID#", "name_address0")) > 0 Then
	{
		Writeln("XLookupAll Worked")
	}
	Else
	{
		Writeln("XLookupAll Failed")
	}

	vReturn = @XLookup("data\pacific coast fruit products.db", vendor0, "contacts!ID#", "name_address0")
	Writeln("Vendor ID: " + @Str(vendor0))
	Writeln("Name and Address: " + vReturn)
	vendor0 = vReturn


	vReturn = @XLookup("data\pacific coast fruit products.db", @Int(vendor0), "contacts!ID#", "name_address0")
	Writeln("Second Return: " + vReturn)
 

-Ray

Hello,

Are you 100% positive that there is a record in 'pacific coast fruit products.db' that has just the value zeljon in the ID# element? Nothing more and nothing less, just zeljon.

-Ray

debmckee wrote on Oct 21^st, 2011 at 8:06pm:


Can you send to support@lantica.com both 'pacific coast fruit products.db' and 'pacific coast fruit products.dat' so that I can have a look at them and see what is going on and why the value is not being returned.

debmckee wrote on Oct 21^st, 2011 at 8:06pm:


The DB and DSR files are completely separate sets of files that are only tied together during a reconcile. So they will have different sets of records in them. This allows a designer to work on design changes throughout the day and not disrupt users who are entering and editing data. The DSR files will have a copy of the records that existed in the DB file at the time of the DSR's creation from that DB file.

To get a current set of your records into DSR file follow these steps.
1: Be sure that your DB file has recently been reconciled. If it has not you will lose any unreconciled changes.
2: Open Sesame Designer
3: Click File->Open Application
4: Choose your .db
5: Click Yes to the message box saying the file already exists. Overwrite?

-Ray