Database

Thanks. But when running i get below error: `Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS AYEAR_, EXTRACT(MONTH FROM VISIT_DATE) AS BMONTH_' at line 10` When i delete last part(ORDER BY), query without any error with below result FEE YEAR_ MONTH_ 3310000 1396 1 is this any things we can do like --> ` SELECT SUM(VISIT_FEE) AS FEE, EXTRACT(YEAR FROM VISIT_DATE) AS YEAR_, EXTRACT(MONTH FROM VISIT_DATE) AS MONTH_ FROM MZS_VISIT_REQUEST WHERE IS_PAY = 1 AND DISTINCT MONTH_ `???

A rubbish question I agree, but not sure why it's a spam setup. Mea culpa, just seen it.

Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query. Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^] How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^] Query Parameterization Cheat Sheet | OWASP[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Sir, I mean the initial steps for installing the database like [radio-button] [selected] Install and configure database [radio-button] Install database [Back] [Next] here Install and configure is the default selected option, all I did is clicked next. since I am a beginner in Oracle database, I've selected the default options without modifying various values. No, sir there is no guest user account in my computer, I have only one account in my PC which is admin Thank you sir for your time and kind help

The member is question seems to have a pathological aversion to using Google for themselves. :sigh:

Member 13161516 wrote: After you have registered all the required data show me this message 1. Could you post the exact message? 2. Could you explain what and how you did? 3. Was it in MS SQL Server or in some other DBMS?

Quote: Any help would be greatly helpful - thanks for all help my friends. As I said last week, if you share the code that you are using to generate the dynamic SQL we may be able to help you improve it

Member 13143024 wrote: give me No. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

tmpConn.ConnectionString = @"Data Source=(LocalDB)\FFw1a;AttachDbFilename='D:\y\2\TestDB_Data.mdf'; Integrated Security=True;Connect Timeout=30;Encrypt=False"; remove this

Thank you for your Response. Yes finally I will save it as text and parse it. It is only curiosity how a structure should look for a relatinal DB. After reading agein Quote: In your TBLS have a parent ID which is self referencing Great idea, thank you so much!:thumbsup:

Have you confirmed that the file exists in that path FROM THE SERVER. Not from your local machine. Never underestimate the power of human stupidity RAH

I was able to achieve that without the date time function.I made it as simple as i could do. But I am having a problem on deployment (publishing)of the program, to beable to run on any system, other than the one I developed with. when I tried to publish,it did publish, but if I try to access the forms that contains a link to the database, I keep getting error, "Microsoft ...... 12.0 or 4.0 (when I saved in 2002 - 2003 format), not installed on local machine. I want to send you the folder that contains the project, but can't, as I cant see where to attach files here.

Tridip Bhattacharjee wrote: searching google for merge join in sql server brings lots of result but i like to know when it is good or should i do it when joining one key is pk or other key is fk or regular key. Try reading the first pages that come back as a result :| Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Hi, I need to get all the Packages that are run either by using Job or without using the Jobs, I need the statuses of those Packages, whether they are failed or success. This is because I have a console application that's executing all the Packages one after the other, but if the Packages failed internally we are not informed of that, so I want to go ahead and check status of the Package after execution using query and find out what has happened. Any help would be greatly helpful. Thanks in advance. I want to get all the packages that are executed either by Job or without using the Job on a database. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Sorry I know nothing about Mendix but it looks like a web development suite. I would look into how mature it is and peruse their support forum to see how responsive they are to problems. [edit] As a caveat to using custom IDEs look at this question then look a the last release date for an update of the product he is using. [How to set up QuickSharp to run program in separate window? - C# Discussion Boards](https://www.codeproject.com/Messages/5371922/How-to-set-up-QuickSharp-to-run-program-in-separat.aspx) Never underestimate the power of human stupidity RAH

I cannot see anything wrong with your parameter indices, unless something else is corrupting those values. You need to use your debugger to step through the code and see exactly what is happening.

ohk cool bro am new here ,In a hurry i forget it happens sometime sorry next tym i will keep this in mind thanks for going through my code