Recent content by sandyas

I am using duplicate, What it does is removes the repeating records but in some cases it ignores certain records and I am not able to find which records it is missing as the results are huge. It affects the total amount which I am calculating. How do I go about it. Thanks

I have a query which should return records irrespective of the field SHIP_METHOD_ID. The query is select "OePo_Item"."ITEM_ID" from "OePo_Item","OeShipMethod","ArClient","OePo_Header","ApVendor" where ("OePo_Item"."SHIP_METHOD_ID" = "OeShipMethod"."SHIP_METHOD_ID" or...

It's working. I used the = instead of between.

I have two dates(range) which is entered through ASP form in MM/DD/YYYY format. The date in the table is stored as YYYYMMDD. I converted d1 and d2 to that form. It has to be checked with the date in the table. "Select date1 from table1 where date1 between '" & d1 & "' and '" & d2 & "'" I...

I got it working

I am using ASP and Pervasive SQL. I even tried with various string functions and it gives type mismatch.

I basically print COC which is a field in the table and need to increment the value of n and r depending on the value of COC. I need to display the value of n and r at the end of the report. The values of the field COC are 'N' and 'R'. I need the display to be as follows: COC ---- N N R N N...

I need to increment values in the IF statement like SELECT IF(SUBSTR(COC,1,1) = 'N', n=n+1, r=r+1) FROM tbl How do I go about it. Thanks

Hi, I have to check for conditions in the select statement. The coulumn to be checked is string select.....................,substr(COC,1,1) as nr FROM ......................... How to use case statement while checking for substrings. The field COC contains either N or R. Thanks

Thanks for helping, as this is my first program with ASP and Pervasive SQL

I tried CONVERT(UNIORDER_QTY,CHAR(15)) and it gives a syntax error. Hope the syntax of Convert is right.

I think one is a numeric and the other is character for it prints as PK/100. The tables are third party and they are read-only.

I get an error "Incompatible types in expression" rs.open "select OePo_Item.ITEM_ID,OePo_Item.DESC_1,convert(left(OePo_Header.PO_DATE,4)" & '-'& "right(left(OePo_Header.PO_DATE,6),2)" & '-' & "right (OePo_Header.PO_DATE,2),SQL_CHAR),UNITORDER_QTY+'/'+UNITCODE_QTY from OePo_Item,OePo_Header...

Hi, How do I concatenate two colums from a table with a '/'. select column1,column2 from table1 The column1 and column2 have to be printed as one column with a '/' in between. How do I do it with concat function or is there any other method. Thanks

I got it right and is working. Thanks for the help