Amicuk Programming Answers

Problem In The Query

2015-10-11   Views:0


Hai All,            I have created a login form in screen painter (which contains two textbox and a login button). When login button is clicked, I want to check whether the username and password matches in the table (@EMPA). I have a problem while ch

Hai All,
           I have created a login form in screen painter (which contains two textbox and a login button). When login button is clicked, I want to check whether the username and password matches in the table (@EMPA).
I have a problem while checking with the query
This is User Defined Function a have used
Private Sub UDFCheckInTableLog()
            Dim rs As SAPbobsCOM.Recordset = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
            rs.DoQuery("SELECT T0.U_user FROM [dbo].[@EMPA]  T0 WHERE T0.U_user ='" & euser & "' AND TO.U_pass ='" & epass & "'")
            rscount = rs.RecordCount
            If rscount > 0 Then
                '//There is a record that Matches
                REC = True
                '//To clear the values in the text box
                '//This means NO Record Matches
                REC = False
            End If
        Catch ex As Exception
            SBO_Application.MessageBox("UDFCheckInTableLog :" & ex.Message)
        End Try
    End Sub
I get this error message
1)[microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'TO'.
2))[microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared.

The replay answer
You're trying to use Table Alias(T0), i'm guessing its not allowed. Try also to remove dbo, try @EMPA or just EMPA.

Go to See the other 6 answers

Problem in Adhoc Query's set operation functionality.

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I am facing problem executing Adhoc Query's set operation functionality. In Selection Tab, following operations are performed :- Execute a query and mark it as 'Set A'.(Say Hit list = X) Execute another query and mark it as 'Set B'.(Say H[More]

Problems in SQL Query

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I am having some problem in SQL query. I am trying to get total sum of one inventory using the following query it works fine: sum(case when mt.transaction_quantity > 0 then (mt.transaction_quantity) else 0 end) "TOT_IN" ,sum(case wh[More]

Problem with a query with a BLOB data type

Category:DefaultRelease time:2015-10-11Views:130

Hi i've a problem with this query in 11g. R1 SELECT       LOGTIMESTAMP,       LOGTIMEMILLIS,       MSGID,       XMLTYPE(MESSAGEBODY, nls_charset_id('AL32UTF8')).getClobVal()  as LLamada FROM     vordel.AUDIT_MESSAGE_PAYLOAD,     vordel.AUDIT_LOG_POIN[More]

Strange problem in a query

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I'm facing a non-sense problem in a query, I hope you could help me. I have defined a structure in the rows of my query. Inside the structure, I have defined several selections and formulas. Selections are basically account intervals and f[More]

Problem in parameter query.

Category:DefaultRelease time:2015-10-11Views:130

Post Author: eaglesoft CA Forum: Data Connectivity and SQL I'm using Crystal reports xi. I have problem on parameter fields.    field name-EmployeeCode, datatype-String.In report,I kept the following query in selection expert,(EmployeeTable.EmployeeC[More]

Problem in xml query

Category:DefaultRelease time:2015-10-11Views:130

Hi I am working on BLS and having problem in xml query.I want to perform some calculation over xml columns.Than total of this as a new column.I can do this part in logic editor itself but can i do these both task by XSLT. Can be made our own XSLT for[More]

Navigational Attribute Problem in Input Query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am having a problem in input query implementation which uses a navigational attribute. I have, for eg, only one char 'customer' in rows; i want to exclude the customers with the status D (deleted) from displaying (Status is nav. attr. of custom[More]

Problem in update Query of  MySQL

Category:DefaultRelease time:2015-10-11Views:130

Hi I have a large amounts of records in a teble & i want to update the records in a particular condition but it takes time in updating. I have also used batch update but it's also not going to solve my problem. can anyone help what should i do to fre[More]

Problem With The Query

Category:DefaultRelease time:-0001-11-30Views:130

Hi gurus, I have a problem in a query I have a lot of records that are the same and I don’t want to sum the value of them more than once. How can this be done?? The following table should illustrate my problem: DEPT--MONTHCFBID----SCORE ALST--APR100-[More]

Problem with Hierarchical query

Category:DefaultRelease time:-0001-11-30Views:130

Gurus, I have a problem with hierarchical query, which I am pasting below. select sys_connect_by_path (Fname,'/')"PATH",Fname,id,level ,(SELECT COUNT(ID)-1 FROM (SELECT CONNECT_BY_ROOT LNAME LNAME,ID FROM CMT_PERSON START WITH ID = 'emplo0000000[More]

Problem with af:query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a problem with af:query. Here's what I do: 1. create a VO, define view criteria 2. drag and drop view criteria from data controls to an empty form, choosing query and table 3. When I run the page and click any of the buttons, I get: "Becau[More]

Hi All Am trying to deploy a sda file from SDM. But am getting this error during the deployment process Caught exception during access of archive ...'the sda archive' java.lang.NullPointerException (message ID: [More]
Hello Guys, I am having a problem in displaying items in a single line in the ALV Grid using event ALV_TOP_OF_PAGE. My requirement is to group items on a single line i.e. in the example below, Vendor code and posting date are on the same line. The ne [More]
After having itunes 7 and stupidly upgrading(IF ITS NOT BROKEN WHY FIX IT OR UPGRADE) now i cannot get itunes to install or delete the programs I deleted all the componets,Apple Mobile support ,Apple Upgrade, Quicktime,iTUNES STLL NO HELP. i HAVE BEE [More]
Hi Everyone, I seek an urgent solution for the following issue. We are trying to do a service entry for an account assigned service PO but are getting the following error message :- ‘Account determination for entry XXXX(chart of accounts) KBS(acct. a [More]
Hello, I appreciate any help possible, but am particularly interested in comments from "Len Goff" and "John Beatty1." This question involves a small experiment. I found errors in iDVD 5 that went unrepaired (yes, I did report them, onc [More]
I have a G4/500 SAWTOOTH-AGP machine. Will an AirPort Extreme card work in this machine? I've looked everywhere, but cannot fine the answer. The specs for the card say "Will only work in machines that are Airport Extreme ready"... I've looked up [More]
I would like to write capacitance (double) and fluxvalue (double) as a function of time to a single file, preferably a spreadsheet.  Currently, each one is written to its own file using "Write LabView Measurement File".  This causes problems in [More]
Hi to all, This is kittu, i want to know what type of abap code will be written on import programs, export programs, and report programs in biw and if we need to make any changes what type of changes can we make. waiting for reply from u all guys. by [More]
My development staff is new to ABAP and the screen painter, and one of those developers is designing a screen with text boxes on it that need to dynamically change according to what is brought back from the database. How would one accomplish that tas [More]
Where do I add a signatureYou might want to look into the [ WiseStamp] extension. You can add signatures to a plethora of websites. I still suggest that you contact the support of the email site tha [More]