Comments
Sort by recent activity
Hi JLueders, Apologies for the extended delay. During the process of finding a solution, a few bugs were encountered that might have been causing the issue. To begin, it’s important to note that using SQL Statement options won’t be necessary. Instead, some changes need to be made in the job table. Specifically, in the default foreign key (Automatic) Column Generation settings, the population method should be set to “All Key Values Unique”. Additionally, the ‘allow nulls’ box for both of the foreign keys, ‘contactid’ and ‘facilityid’, should be unchecked. [image] [image] [image] This should help in resolving the issue. Best regards, Hassan Product Support Engineer / comments
Hi JLueders,Apologies for the extended delay. During the process of finding a solution, a few bugs were encountered that might have been causing the issue.To begin, it’s important to note that usin...
Hi JLueders, Thank you for your patience and for providing detailed information regarding your table structures. Regarding the challenge you're facing with the FacilityId and ContactId combination When a column is set with the IDENTITY property, it's controlled by the server to auto-generate values. This ensures uniqueness and is typically used for primary key columns. If you're trying to generate or insert specific values into an identity column, such as Id in your Jobs table, In order to generate into that column, you need to remove that IDENTITY constraint. After that is removed you can move forward without using SQL Statements and just set the relation to user defined foreign key for the column Best, Hassan Product Support Engineer / comments
Hi JLueders,Thank you for your patience and for providing detailed information regarding your table structures.Regarding the challenge you're facing with the FacilityId and ContactId combination W...
Hey JLueders,
Thank you for your patience and providing the DDL for your tables. I'll need a bit more time to thoroughly test and ensure we have a script that works seamlessly for your requirements. Please bear with me; I should have a solution ready for you by Thursday.
Warm regards,
Hassan
Product Support Engineer
/ comments
Hey JLueders,
Thank you for your patience and providing the DDL for your tables. I'll need a bit more time to thoroughly test and ensure we have a script that works seamlessly for your requireme...
Hi Leuders, I sincerely apologize for the delay in addressing your concern. Regarding the error message "Not enough rows for column 'FacilityId'", Im not seeing this on my end. Could you kindly share the DDL for your tables? This will enable me to replicate and further investigate the matter. All the best, Hassan Product Support Engineer / comments
Hi Leuders,I sincerely apologize for the delay in addressing your concern. Regarding the error message "Not enough rows for column 'FacilityId'", Im not seeing this on my end. Could you kindly shar...
Hi JLueders, Thank you for reaching out regarding SQL Data Generator. For aligning the ContactId and FacilityId combination in the Jobs table with valid entries in the Contacts table, I recommend utilizing the automatic "Foreign Key generator". This option seamlessly maps and references the primary key relationships in your database, ensuring data consistency. For a more information, please refer to our documentation: Using Generators (SQL Data Generator Documentation) Warm regards, Hassan Product Support Engineer / comments
Hi JLueders,Thank you for reaching out regarding SQL Data Generator. For aligning the ContactId and FacilityId combination in the Jobs table with valid entries in the Contacts table, I recommend ut...
Hi JLueders, Thank you for providing clarity on the issue. To ensure that the FacilityId in the Jobs table matches the one associated with the chosen ContactId in the Contacts table, we need a custom solution. For the FacilityId column in the Jobs table, instead of using the default foreign key generator (which just ensures it's a valid facility), use the "SQL Statement generator." The statement will fetch the corresponding FacilityId for the generated ContactId . The SQL statement would be something like: SELECT FacilityId FROM Contacts WHERE Id = [Jobs].[ContactId] / comments
Hi JLueders,Thank you for providing clarity on the issue. To ensure that the FacilityId in the Jobs table matches the one associated with the chosen ContactId in the Contacts table, we need a custo...
Hi JLueders, Thank you for reaching out regarding SQL Data Generator. For aligning the ContactId and FacilityId combination in the Jobs table with valid entries in the Contacts table, I recommend utilizing the automatic "Foreign Key generator". This option seamlessly maps and references the primary key relationships in your database, ensuring data consistency. For a more information, please refer to our documentation: Using Generators (SQL Data Generator Documentation) Warm regards, Hassan Product Support Engineer / comments
Hi JLueders,Thank you for reaching out regarding SQL Data Generator. For aligning the ContactId and FacilityId combination in the Jobs table with valid entries in the Contacts table, I recommend ut...
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, We updated SQL Prompts capabilities in the lastest release, which includes: Added intellisense support to EXTENDED EVENTS syntax.
SQL Prompt Latest Warm regards, Hassan Product Support Engineer / comments
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, We updated SQL Prompts capabilities in the lastest release, which includes: Added intellisense support to EXTENDED EVENTS sy...
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, We updated SQL Prompts capabilities in the lastest release, which includes: Added intellisense support to EXTENDED EVENTS syntax.
SQL Prompt Latest Warm regards, Hassan Product Support Engineer / comments
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, We updated SQL Prompts capabilities in the lastest release, which includes: Added intellisense support to EXTENDED EVENTS sy...
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, the tool does not offer code completion during SQL Event scripting. However, I've brought this to the attention of our development team, and they are actively exploring the possibility of integrating this feature into the tool's capabilities. Warm regards, Hassan Product Support Engineer / comments
Hi Jpaw, Thank you for reaching out regarding SQL Prompt. At the moment, the tool does not offer code completion during SQL Event scripting. However, I've brought this to the attention of our devel...