RoboTask forum

Maybe I could give you an SQL-Statement, which creates the table structure. Other thing to know is, that every system here is working with english versions. But this - in combination with german region settings - should not make trouble, right?

I made a test with your SQL-statment. The only thing is changed is one more "(" and ")": Your source: SELECT Belegnummer, Belegart FROM KHKVKBelege WHERE (Periode = 2014006) AND ((Belegart = 'Sofortrechnung' OR Belegart = 'Direktrechnung' OR Belegart = 'Rechnung')) My source: SEL...

To copy fields does not work well in Management Studio:

Thanks for your help. Here are the fields and datatypes for KHKVKBelege: Mandant smallint Unchecked TransferID int Unchecked Transferart varchar(40) Unchecked BelID int Checked Belegtyp smallint Checked Zeitpunkt datetime Checked Information text Checked Dateiinhalt text Checked Parameter text Check...

In Management Studio (2008 R2) everything works well. The statement is correct (field value "2014006 is correct).

;***************************** ;* RoboTask Task file ;* Do not edit in text editor! ;***************************** [Root] ActionAfterRun=INTEGER|0 Actions=FOLDER Automat=INTEGER|-1 CatID=INTEGER|0 Comment=STRINGLIST ContinueOnError=INTEGER|0 ExternalName=STRING|"Task3" Hide=INTEGER|0 ID=I...

Hello together, I want to use SQL-Statements in my RoboTasks. It seems to be a problem, if I use statements with some where-clauses. This version for example works: SELECT Belegnummer, Belegart FROM KHKVKBelege WHERE (Belegart = 'Sofortrechnung' OR Belegart = 'Direktrechnung' OR Belegart = 'Rechnung...