Easy question for any successful user

A place for users and developers of the Xataface to discuss and receive support.

Easy question for any successful user

Postby thesnowsnake » Fri Aug 26, 2011 1:31 pm

I have two tables .

A: client (big Source)

B: Feedback (Many to one)
This is my relationships.ini in the client directory.

[feedback]
feedback.client_ref = "$Idclient"

This Is what I used and It fails: :cry:

Is it because the field in the feedback table must be exactlly the same as the Primary Index field in the client table?? like
so:
[feedback]
feedback.Idclient = "$Idclient"

Just a question before I change the main database tables.. :roll:
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby shannah » Fri Aug 26, 2011 4:04 pm

When you say "it fails", what happens? (e.g. error message).
That syntax looks ok if you have a client_ref field in your feedback table which contain ids of client records. And your client table includes an Idclient field.

Note that everything is case sensitive.
Is it because the field in the feedback table must be exactlly the same as the Primary Index field in the client table??


All that is necessary is that your stated condition is true. I.e. That relationship will contain records from the feeback table having client_ref equal to the Idclient field of the source client record.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Easy question for any successful user

Postby thesnowsnake » Fri Aug 26, 2011 4:50 pm

I see nothin in the feedback table after the grid displays the correct client.

I have checked spelling and caps.

This is the actual relations.ini from cliect directory eg:
/public_html/XXXXXXX/tables/client


[feedback]
feedback.client_ref = "$Idclient"
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby shannah » Fri Aug 26, 2011 7:29 pm

relations.ini

Do you mean relationships.ini?

I see nothin in the feedback table after the grid displays the correct client.


Can you elaborate on this? Do you click on a client in list view and see a blank screen? Or do you see the client details, then click on the "feedback" relationship subtab where you see an empty list, or ... ??????
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Easy question for any successful user

Postby thesnowsnake » Fri Aug 26, 2011 9:59 pm

Ok I find the client Johnathon Tait (he has feedback 4 sure)

screen1.gif
screen1.gif (24.61 KiB) Viewed 3071 times


Then press feed back side tab:
and get this:


screen2.gif
screen2.gif (37.55 KiB) Viewed 3071 times


I know there is feedback check this:
screen3.gif
screen3.gif (23.14 KiB) Viewed 3071 times


The system seems easy but I must have missed something

Thanks Again
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby shannah » Sat Aug 27, 2011 8:02 am

What happens when you click on jonathons feedback tab?
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Easy question for any successful user

Postby thesnowsnake » Sat Aug 27, 2011 9:35 am

This is the tab I press :

screen 67.gif
screen 67.gif (24.52 KiB) Viewed 3067 times

And this is what I see (looks like all the test fields)




screen66.gif
screen66.gif (57.5 KiB) Viewed 3067 times

Don
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby shannah » Sun Aug 28, 2011 6:58 am

Not the feedback table tab. The feedback relationship tab. It is one of the green tabs under the JONATHON heading.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Easy question for any successful user

Postby thesnowsnake » Sun Aug 28, 2011 7:52 am

OK sorry its the only one that had results:

Listen I can change the names of the feedback fields at this point..(FYI)

new screen.gif
new screen.gif (19.81 KiB) Viewed 3065 times
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby thesnowsnake » Sun Aug 28, 2011 8:30 am

OK maybe I have the files inthe wrong place.

I have main program in public_html/dataface/dataface/Etc
And my relationships.ini and fields.ini are located in:

/public_html/IouGuy/tables/client

Does this look ok. I changed it from the original /public_html/iouguyc1/
then created tables etc.
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby thesnowsnake » Sun Aug 28, 2011 9:08 am

The basic seems to work ok but im reaching right now..Enjoy your weekend....Summers fadin...
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby thesnowsnake » Sun Aug 28, 2011 2:16 pm

OK now I duplicated all files back into the original. still no luck hmmm maybe a fresh start..

What do you think?

I maybe made a simple mistake..(It's possible LOL)
thesnowsnake
 
Posts: 23
Joined: Thu Jul 28, 2011 9:02 am

Re: Easy question for any successful user

Postby shannah » Wed Aug 31, 2011 7:12 pm

No need to start fresh. Your sticking point is the relationship. Clearly the query defined in the relationship definition yields an empty set for that record for some reason. You should investigate that and only that.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 24 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved