Stack Overflow
Stack Overflow

Questions tagged [rapidsql]

Rapid SQL is a SQL IDE allowing SQL scripting, query building, object management, debugging and version control.

Rapid SQL is a SQL IDE allowing SQL scripting, query building, object management, debugging and version control.

http://www.embarcadero.com/products/rapid-sql

23 questions
0
votes
1 answer

SSRS Could not update a list of fields for the query

I am trying to create a report, but my query seems to be causing problems even though it runs fine on Rapid SQL 8.5. The specific error message is below: Could not update a list of fields for the query. Verify that you can connect to the data…
Jon
  • 140
  • 2
  • 15
0
votes
1 answer

Need to optimize query and loop the dates

I have a SQL query that needs to be optimized and loop cp_ex_dt field from 1st July to 20th August. Right now i have to individually Run for each date and save the output in csv file. Can someone suggest me the best way to run this? Is there…
vDs1
  • 156
  • 1
  • 2
  • 10
0
votes
1 answer

The object name contains more than the maximum number of prefixes. The maximum is 2

I am trying to pull records from two tables in different servers using single query. I am using the below format in select query .... but all i get is the above error. is there a way i can pull records from two servers in single query like select *…
Harish
  • 1
  • 1
  • 2
0
votes
2 answers

Select Max Distinct Dates from list of Dates

I have a table which is a list of dates with times. For example Dates 1/3/2014 6:16:43.570 AM 1/3/2014 6:17:02.300 AM 1/3/2014 6:23:09.700 AM 1/6/2014 6:02:09.993 AM 1/6/2014 6:02:34.323 AM 1/6/2014 6:03:02.957 AM 1/6/2014 6:08:48.867 AM 1/6/2014…
user3166440
  • 1
0
votes
1 answer

RapidSQL Shortcuts

I'm using RapidSQL 7.3.3 on a project and can't find any documentation on shortcuts. I'm just looking for the general things like commenting out a number of lines at once and anything else that would spead my work up. If anyone knows a resourse or…
Dave Ward
  • 97
  • 1
  • 12
0
votes
1 answer

Methods to export Sybase table data using RapidSQL

I am trying to export Sybase DB tables using RapidSQL. I am accessing the DB tables as a client as the DB resides on a remote server. I need to dump the table contents separated by commas onto my local machine. What are some methods this can be…
czchlong
  • 2,294
  • 10
  • 45
  • 61
-1
votes
1 answer

QUERY [VIRTUAL] [ERROR] in DBeaver while querying the table in Denodo

I ran this query in DBeaver SELECT DLY.badge_nbr, DLY.DIM_DT_ID,attribute_type FROM FACT_MDM_DAILY_INT DLY WHERE SCENARIO_TYPE = 'VOLTAGE' AND ATTRIBUTE_TYPE = 'Phase_A_Average_RMS_Voltage' AND DLY.dim_dt_id >=…
Ajaya Rk
  • 5
  • 6
-1
votes
1 answer

Is there a way to see the SQL executed by Rapid SQL for stored procs?

Using the Embarcadero Rapid SQL client tool, you may list Procedures from a database, right-click one a choose "Execute" which opens up a dialog where you can enter the input parameter values, then click the Execute button to run the procedure and…
Trant
  • 2,911
  • 4
  • 29
  • 53
1
2