Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Data base issues

Avatar

Level 2

i have created the data base but i am unable to get all the buttons to work properly it always show the error in sql query as the image given blow what is the possible reason to not to exicute the queiry in sql

i also wants to create user defined database is it possible?

is it possible to add key board shortcut for form buttons?

error.png

5 Replies

Avatar

Level 3

In the screenshot I can see that you do not have space between column name mobile and keyword from. Please give a single space and then check the issue.

It becomes easy when you first write command in SQL query analyzer and test it there. IF it executes successfuly you can copy - paste to designer OLEDB connection window.

Avatar

Level 2

i have tried the same as instructed by you but it dosent works i have written the sql query as below.

"SELECT FirstName, MiddleName, LastName, Age, Gender, MonthlyIncome, Profession, Address, PhoneNumber, Email, Mobile FROM Survey;" let me know how i can correct the same.

regards

uma shankar

Avatar

Level 3

Please post your "connection string" to check which connection you are using.

Do you get  "Test connection succeeded" under Data Link Properties window when "Test connection" button is clicked.

Try using select * from Survey and check the result.

oledb.jpg

Avatar

Level 2

please find the connection string which was created after the connection succeeded as you shown in the screen shoot the:

"Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=C:\Users\UMASHANKAR\Desktop\Survey.accdb;DefaultDir=C:\Users\UMASHANKAR\Desktop;Driver={Microsoft Access Driver (*.mdb, *.accdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\Users\UMASHANKAR\Desktop\Survey.accdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;";Initial Catalog=C:\Users\UMASHANKAR\Desktop\Survey.accdb"

in this project all buttons except the add button is performing well, when i have press the add button to add the next record all the buttons gets hange why?

regards

uma shankar

Avatar

Level 2

i want's to give a dynamic path instead to static path in form database is it possible? it is just because when i am running the form on my home pc it works well but as well as i am shifting it to my office pc along with its database it dosen't works well. rather it behave like a static form as per my requirement i need a dynamic form instead of static form.