[FX.php List] Error Number: 201

[Vision Computer Consulting]

Yes to all

The code is:

$layout = $this->layout;
			//echo $layout;
			$my_fx->SetDBData($db,$layout);
			if($subaction != 'add_property') {
				$my_fx->AddDBParam('-recid',$propertyID);
			} else {
				$my_fx->AddDBParam('kf_Broker',$cID);
			}
			$my_fx->AddDBParam('Prop_HSE',$property_details[Prop_HSE]);
			$my_fx->AddDBParam('Prop_Street',$property_details[Prop_Street]);
			$my_fx->AddDBParam('Prop_City',$property_details[Prop_City]);
			$my_fx->AddDBParam('Prop_State',$property_details[Prop_State]);
			$my_fx->AddDBParam('Prop_Zip',$property_details[Prop_Zip]);
			$my_fx->AddDBParam('Map_Page',$property_details[Map_Page]);
			$my_fx->AddDBParam('Prop_Status',$property_details[Prop_Status]);
			$my_fx->AddDBParam('Prop_Occupancy',$property_details 
[Prop_Occupancy]);
			$my_fx->AddDBParam('Date_Listed',$property_details[Date_Listed]);
			$my_fx->AddDBParam('Lock_Box_Code',$property_details[Lock_Box_Code]);
			$my_fx->AddDBParam('Date_Closed',$property_details[Date_Closed]);
       		$my_fx->AddDBParam('Lend_Company',$lender_details 
[Lend_Company]);
			$my_fx->AddDBParam('Lend_Website',$lender_details[Lend_Website]);
			$my_fx->AddDBParam('Lend_Notes',$lender_details[Lend_Notes]);
			$my_fx->AddDBParam('Asset_Contact',$lender_details[Asset_Contact]);
			$my_fx->AddDBParam('Asset_Addr',$lender_details[Asset_Addr]);
			$my_fx->AddDBParam('Asset_City',$lender_details[Asset_City]);
       		$my_fx->AddDBParam('Asset_State',$lender_details[Asset_State]);
       		$my_fx->AddDBParam('Asset_Zip',$lender_details[Asset_Zip]);
			$my_fx->AddDBParam('Asset_Phone1',$lender_details[Asset_Phone1]);
			$my_fx->AddDBParam('Asset_Phone1_Ext',$lender_details 
[Asset_Phone1_Ext]);
			$my_fx->AddDBParam('Asset_Phone2',$lender_details[Asset_Phone2]);
			$my_fx->AddDBParam('Asset_Fax',$lender_details[Asset_Fax]);
			$my_fx->AddDBParam('Asset_Email',$lender_details[Asset_Email]);
       		$my_fx->AddDBParam('AP_Contact',$lender_details[AP_Contact]);
       		$my_fx->AddDBParam('AP_Addr',$lender_details[AP_Addr]);
			$my_fx->AddDBParam('AP_City',$lender_details[AP_City]);
			$my_fx->AddDBParam('AP_State',$lender_details[AP_State]);
			$my_fx->AddDBParam('AP_Zip',$lender_details[AP_Zip]);
			$my_fx->AddDBParam('AP_Phone1',$lender_details[AP_Phone1]);
			$my_fx->AddDBParam('AP_Phone1_Ext',$lender_details[AP_Phone1_Ext]);
       		$my_fx->AddDBParam('AP_Phone2',$lender_details[AP_Phone2]);
       		$my_fx->AddDBParam('AP_Zip',$lender_details[AP_Zip]);
			$my_fx->AddDBParam('AP_Phone1',$lender_details[AP_Phone1]);
			$my_fx->AddDBParam('AP_Phone1_Ext',$lender_details 
[Asset_Phone1_Ext]);
			$my_fx->AddDBParam('AP_Phone2',$lender_details[AP_Phone2]);
			$my_fx->AddDBParam('AP_Fax',$lender_details[AP_Fax]);
			$my_fx->AddDBParam('AP_Email',$lender_details[AP_Email]);
			
			if($subaction != 'add_property') {
				//echo 'here';
				$fx_Result=$my_fx->FMEdit();
			} else {
				//echo 'here2';
				$fx_Result=$my_fx->FMNew();
			}
			
			$error = $fx_Result['errorCode'];
			
			//echo "Error: $error<br />";
			
			return $error;





On Jun 25, 2007, at 3:24 PM, Dale Bengston wrote:

> Are you using the same input form to collect your user input for  
> both add and edit? Are you calling the same FX function to send the  
> data to FMP? Are you accessing the same FMP layout for your FMNew()  
> and FMEdit() calls?
>
> Dale
>
>
> On Jun 25, 2007, at 1:23 PM, Vision Computer Consulting wrote:
>
>> FM New works. FMEdit work if I don't change one field. If I try to  
>> change that on field FMEdit throw an error 201.
>>
>> On Jun 25, 2007, at 10:52 AM, Gjermund Gusland Thorsen wrote:
>>
>>> What are you saying?
>>>
>>> FMNew() works?
>>> but FMEdit() does not?
>>>
>>> ggt667
>>>
>>> On 6/25/07, Vision Computer Consulting
>>> <info at visioncomputerconsulting.com> wrote:
>>>> Thanks. Tried that, but no change in this case.
>>>>
>>>>
>>>> On Jun 25, 2007, at 10:27 AM, David Ness wrote:
>>>>
>>>> > Might be a corrupt layout. It happens. Has happen to me a  
>>>> couple of
>>>> > times.
>>>> >
>>>> > Create a blank layout (not a duplicate) with the same name, copy
>>>> > all the
>>>> > fields from the original layout to the new one. Delete the  
>>>> original
>>>> > layout.
>>>> >
>>>> >
>>>> >
>>>> > David Allen Ness
>>>> > Database Systems Programmer
>>>> > Web Applications Developer
>>>> >
>>>> >
>>>> > -----Original Message-----
>>>> > From: fx.php_list-bounces at mail.iviking.org
>>>> > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Vision
>>>> > Computer Consulting
>>>> > Sent: Monday, June 25, 2007 1:12 PM
>>>> > To: FX.php Discussion List
>>>> > Subject: [FX.php List] Error Number: 201
>>>> >
>>>> >
>>>> > I am able to update all the fields except 1. When I do I get a  
>>>> 201
>>>> > error (Field is missing)
>>>> >
>>>> > I checked that the data is present in the function that is  
>>>> doing the
>>>> > update. I can modify the field ini FM.
>>>> >
>>>> > Need help with what this error really  means or where to look.
>>>> > _______________________________________________
>>>> > FX.php_List mailing list
>>>> > FX.php_List at mail.iviking.org
>>>> > http://www.iviking.org/mailman/listinfo/fx.php_list
>>>> > _______________________________________________
>>>> > FX.php_List mailing list
>>>> > FX.php_List at mail.iviking.org
>>>> > http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list