mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 5:14 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:01 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
Hi everyone,

I have some trouble with the following piece of code:

Code: Select all
FORM.RUN(Form1, Record1);

Record1 is a record of type Customer while Form1 is has rec.Customer as Source Table...

While running the code I get the following error message:
Code: Select all
The specified table (Customer) is different from the table the form uses(rec.Customer)


How can I fix that???How should I define Record1 to make it work???


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:04 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
Are you sure SourceTable of the form1 is Rec.Customer?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:11 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
Yes, of course :?


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:15 am 
Offline

Joined: Thu Jan 29, 2009 5:06 pm
Posts: 351
Location: Sofia
Country: Bulgaria (bg)
So, you're telling you have a table named "Customer" and table named "Rec.Customer". Am I right? :roll:

If so, the error is correct. The Record must be the same as the SourceTable property.

_________________
-Mihail- [MCTS]


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:26 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
In the SourceTable property of the form, I found Rec.Customer...
But I couldn't define a record of type Rec.Customer...I get the following error:
Code: Select all
You cannot enter 'Rec.Customer' in TableNo.


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:33 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
You should mention Table No. in SourceTable property not the field..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:44 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
I don't really understand....

What I did is that I tried to define a record variable in the C/AL Globals menu...When I tried to put Rec.Customer in the Subtype field, I got the error message....

What are you suggesting to do???


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:50 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
poppins wrote:
In the SourceTable property of the form, I found Rec.Customer...

In SourceTavle property of form you have to enter Table No./Name not the Field from table..
so make it to Customer and try..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:53 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
With Customer in the SourceTable, it works, but I want to make it work without modifying the SourceTable...is it possible???


Top
 Profile E-mail  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:54 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4224
Location: New Delhi
Country: India (in)
poppins wrote:
With Customer in the SourceTable, it works, but I want to make it work without modifying the SourceTable...is it possible???

No :thumbsdown:

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Source Table =Rec.Customer
PostPosted: Mon Jul 16, 2012 10:56 am 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 269
Country: France (fr)
OK :D


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: