Please check my code?

[bdjb]

I have make table query, where I get the error "the command did not produce any data, and did not create any rows." The Select portion works fine by itself. What am I missing?

Create table Title ("EntityID" CHAR(24), "EntityRole" CHAR(16), "Office" CHAR(50), "Borrower" CHAR(64), "Client_Name" CHAR(64), "Client_Number" CHAR(24), "FieldNum" INTEGER, "EntityRole_1" CHAR(16),
"ClosedFlag" INTEGER, "TheStatus" CHAR(16), "AssocNum" INTEGER, "Dates" MEMO);

INSERT INTO Title(EntityID, EntityRole, Office, Borrower, Client_Name, Client_Number, FieldNum, EntityRole_1, ClosedFlag, TheStatus, AssocNum, Dates)

SELECT "ENTITIES_FC"."EntityID", "ENTITIES_FC"."EntityRole", "OFFICE"."FirstName", "ENTITIES_FC"."RefName", "CLIENT"."RefName", "CLIENT"."EntityID", "EQANSWER_FC"."FieldNum",
"EQANSWER_FC"."EntityRole", "ENTITIES_FC"."ClosedFlag", "ENTITIES_FC"."TheStatus", "ERELATED"."AssocNum", "EQANSWER_FC"."AnswerText"
FROM ((("ENTITIES" "ENTITIES_FC" INNER JOIN "ERELATED" "ERELATED" ON "ENTITIES_FC"."EntityNum"="ERELATED"."EntityNum") INNER JOIN "ENTITIES" "OFFICE" ON "ENTITIES_FC"."Party0Num"="OFFICE"."EntityNum")
INNER JOIN "ENTITIES" "CLIENT" ON "ENTITIES_FC"."Party3Num"="CLIENT"."EntityNum") INNER JOIN "EQANSWER" "EQANSWER_FC" ON "ENTITIES_FC"."EntityNum"="EQANSWER_FC"."EntityNum"
WHERE "EQANSWER_FC"."EntityRole"='FORECLOSURE' AND "ENTITIES_FC"."EntityRole" LIKE 'FC_%' AND "ENTITIES_FC"."ClosedFlag"=0 AND
"Entities_FC"."TheStatus" Not Like 'dFC_C%' AND "Entities_FC"."TheStatus" Not Like 'bFC_C%' AND "Entities_FC"."TheStatus" Not Like 'dbFC_C%' AND "EQANSWER_FC"."FieldNum" In (1, 4, 5);

 

[SQLBill]

What database are you using? I don't believe SQL Server has a "Memo" data type. It looks like you are using either Access or MySQL. If so, then you should post in one of those forums as this is specifically for Microsoft SQL Server.

If you are using SQL Server, then that is one of your issues - there is no Memo data type.

-SQLBill



The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[markros]

May be MEMO is a user defined type?

PluralSight Learning Library

 

[bdjb]

Thanks for the replies, it is an Advantage databse, and there are no forums for that here. The memo type is what the db says the field is.

Thanks

 

[SQLBill]

markros....I thought that could be it...but there wasn't any code creating it as a user defined type.

bdjb,

Unfortunately, I don't think we'll be able to help you then. Any advice we give you would be based on SQL Server's TSQL and except for the MEMO data type, it actually looks like it should work without issue. Google'ing it shows it appears to be a SyBase database. I suggest searching the forums (Find Forum) for SyBase.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875