Thread: db program access GetFieldValue

Hi, I have been doing minor db programing for about a year, and ran into some strange results off of some joint table queries from the same db.

The querie itself is fine, its the output that fails to meet the criteria I am looking for. I think my querie is ok, but the way I am requesting the output seems have conflicts because two of three tables I join have the same column headings I am requesting. Is there anyway using GetFieldValue to clarify the table and column to prevent this. Below is some code to show what I mean.

Code:

rec.GetFieldValue("ship_label_id", shipLabel);
				fout<<shipLabel<<"\t";
				rec.GetFieldValue("actual_weight", actualWeight);
				fout<<actualWeight<<"\t";
				rec.GetFieldValue("user_id", employee);
				fout<<employee<<"\t";
				rec.GetFieldValue("status", status);
				//translate the status for user in reporting
				if ((strcmp(status, statzero)==0))
				{
					fout<<"Not Picked"<<endl;
				}
				if ((strcmp(status, statone)==0))
				{
					fout<<"Picked"<<endl;
				}
				if ((strcmp(status, statthree)==0))
				{
					fout<<"Short"<<endl;
				} 
				rec.GetFieldValue("status", cstat);
				//translate the status for user in reporting

Any help in understanding this is greatly appreciated. Thanks-

let's see your query, you would specify that in the query not in the code to read the response.

sorry for the late response, my query is below, however, when I plug the query into access, I get the response I am looking for, I truly believe this is how I am calling for the results within the getfieldvalue, however, I've been wrong before, many times before, so any help is always appreciated.

query:

Code:

SELECT [Order].[store_nbr], [Order].[misc_field_4], [Order].[ship_route], [Orderl].[order_seq], [Carton].[tracking_id], [Orderl].[misc_field_5], [Orderl].[slot_name], [Orderl].[freight_class], [Orderl].[q_ordered], [Orderl].[inner_pack], [Orderl].[q_picked], [Orderl].[cust_sku_desc], [Orderl].[ship_label_id], [Carton].[actual_weight], [Orderl].[user_id], [Orderl].[status], [Carton].[status] FROM [Order], [Orderl], [Carton] WHERE (([Order].[order_seq] = [Orderl].[order_seq]) AND ([Orderl].[ship_label_id] = [Carton].[ship_label_id]) AND ([Order].[store_nbr] = 70));