Відео

Hey @LekkyDev, glad to hear this video was useful. Thanks for letting me be a small part of your programming journey.

Very happy to read your comment. Thanks!

@@SoftwareNuggetswelcome! I was wondering if you could help me out with a college project of mine, i m in my last semester and really stuck in an issue. Im willing to pay if you finish the job! 😄

#Sanketjoice. Thanks for reaching out. I am willing to help you with your college project. I am not available for work for hire. If you'd like for me to help, please explain the problem you need help solving. send to my email address: softwareNugget65@gmail.com

Hey @LekkyDev, I will have a video out tonight, however, I could just upload the source to this problem to my github account earlier if you'd like. Please let me know. If no response, I'll just publish video ASAP.

@@SoftwareNuggets That would be great if you could upload the source but videos are always better because you get to see the build up as well. I really struggle to find any tutorial about plpgsql with nodejs. Thanks for reaching back and looking forward to the source and the video.

@LekkyDev, I will upload the video at 7pm tonight. Look forward to hearing comments from you.

@@SoftwareNuggets Wow thanks in advance. Its past 9pm already central euro time. Still waiting.

I reschedule for 6pm.

Thanks

NO. uniqueIdentifier does not have such a function. However, CREATE TABLE UParent ( ParentID UNIQUEIDENTIFIER PRIMARY KEY, ParentName VARCHAR(100) ); -- Create the child table CREATE TABLE UChild ( ChildID UNIQUEIDENTIFIER PRIMARY KEY, ChildName VARCHAR(100), ParentID UNIQUEIDENTIFIER, FOREIGN KEY (ParentID) REFERENCES UParent(ParentID) ); DECLARE @ParentID UNIQUEIDENTIFIER = NEWID(); -- Insert into UParent INSERT INTO UParent (ParentID, ParentName) VALUES (@ParentID, 'Parent Name'); -- Insert multiple children for this parent INSERT INTO UChild (ChildID, ChildName, ParentID) VALUES (NEWID(), 'Child 1', @ParentID), (NEWID(), 'Child 2', @ParentID), (NEWID(), 'Child 3', @ParentID); -- Optionally, you can select the inserted data to verify SELECT * FROM UParent WHERE ParentID = @ParentID; SELECT * FROM UChild WHERE ParentID = @ParentID;

Thanks Mr Harrison, appreciate the "love"

Much appreciated

Appreciate the message

Much appreciated.

Which solution helped you?

@@SoftwareNuggets including function procedure under $$ for creating function

much appreciated

Adding unit test.mock for this app now. I’ll let you know when that is complete.

Hey @WilsonMar1, I created a unit test for: tic_tac_toe_pro.py Please download three files from my github account github.com/softwareNuggets/Python_TKInter_Tic_Tac_Toe 1) tic_tac_toe_pro.py 2) test_tictactoe.py 3) test.bat Please give me back some feedback if this "is" or "is not" what you were looking for. Scott

Hey @paulinaocaranza1154, for sure, this is a great utility to be used from your CMD in Windows.

Hey @Ash-ts6bd, much appreciated.

Thanks, I also have 3 playlist full of videos about PostgreSQL. All simple to follow so you can build skills.

Hey @abdulrehmanjaved-rt8jq, Let me start of by showing you a very simple function that uses the INOUT clause: CREATE OR REPLACE FUNCTION update_value(INOUT num_param INT) AS $$ BEGIN num_param := num_param + 10; -- Increase the value by 10 END; $$ LANGUAGE plpgsql; -- NOTICE there is NOT a return clause on that function. --INOUT means, you send a value into that function (the IN) part, and (the out) part is available to the caller Here is how you call: SELECT * FROM update_value(5) AS result; notice the output of the call: num_param equals 15 Your question was, why do we use this. If you want to call a function, and want to set the behavior of a column to be both input and output, then use INOUT. CREATE TABLE IF NOT EXISTS orders ( id SERIAL PRIMARY KEY, total DECIMAL(10, 2) ); CREATE TABLE IF NOT EXISTS order_items ( id SERIAL PRIMARY KEY, order_id INT REFERENCES orders(id), price DECIMAL(10, 2), quantity INT ); -- Insert sample data INSERT INTO orders (id) VALUES (1), (2); INSERT INTO order_items (order_id, price, quantity) VALUES (1, 10.00, 2), (1, 15.50, 1), (2, 5.75, 3), (2, 20.00, 1); DROP FUNCTION calculate_total_cost(integer) CREATE OR REPLACE FUNCTION calculate_total_cost(inout order_id INT, OUT total_cost DECIMAL) AS $$ BEGIN SELECT SUM(price * quantity) INTO total_cost FROM order_items WHERE order_items.order_id = calculate_total_cost.order_id; -- Update the order with the calculated total UPDATE orders SET total = total_cost WHERE id = order_id; END; $$ LANGUAGE plpgsql; SELECT * FROM calculate_total_cost(1); in the function calculate_total_cost, change order_id from INOUT to IN; run this sql statement: SELECT * FROM calculate_total_cost(1); compare the return columns from the first function code, to the "change INOUT to IN" code results. Hope this helps. Scott

@@SoftwareNuggets Thanks for great explaination, appreciated.

Your welcome

Hey @NirojMeshram, much appreciated.

hey @001KW9, please send the JSON you are using. If you have attempted to create a C# class object, you can send that too, however, I can start from scratch if necessary. send to: softwareNugget65@gmail.com

@@SoftwareNuggets sent

I have not received: softwarenugget65@gmail.com

I got it

@@SoftwareNuggets Will send you the received json content tomorrow

are you trying a deserialize a json file into a c# class?

Much appreciated

Hope it was helpful

Hey @user-xo3cr1re8v, I have a UA-cam video, in the first 20 second, I show you where to get this database: ua-cam.com/video/9aXD69xBvMs/v-deo.html Just to download: www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/ Hope this help!

Hey @truthseeker9988, a listbox normally displays one "field". You can put two fields together, and make one field debit | Credit { " $0.00 | $13.56" } or you can use a TreeView control. <code> import tkinter as tk from tkinter import ttk def main(): # Create the main application window root = tk.Tk() root.title("Debit and Credit Columns") root.geometry("400x300") # Create the Treeview widget tree = ttk.Treeview(root, columns=("Debit", "Credit"), show='headings') tree.heading("Debit", text="Debit") tree.heading("Credit", text="Credit") tree.pack(fill=tk.BOTH, expand=True) # Insert sample data into the Treeview data = [ ("100.00", "0.00"), ("0.00", "50.00"), ("200.00", "0.00"), ("0.00", "100.00") ] for item in data: tree.insert("", "end", values=item) # Run the main event loop root.mainloop() if __name__ == "__main__": main() </code>

@@SoftwareNuggets How? Is there a video about this?

I have a video about using a Treeview control, this "may" be helpful. ua-cam.com/video/cuIjKMPRn0k/v-deo.html Tell me some more about your problem? 1) where is the data coming from? (a database, json, mongodb)? 2) why do you want to show debit and credit in a list? -- Copy the code I wrote above in a file called: tree.py; then use IDLE or your favorite editor and run that code.

I appreciate the comment! Thanks.

Thank you for watching several videos and leaving comments. Much appreciated.

@@SoftwareNuggets My pleasure!

Hey @DoctorMGL, I agree with you 100%. Great comment. I've also learned over the years that Observable Collections offer convenience for handling dynamic data, its reliance on events can indeed be a performance bottleneck with large datasets.

Hey @hamzas4117, glad to hear this video was very helpful. Thanks for letting me be part of your learning journey.

Hey @jaibhavsar1, try this: where LOWER(your_column) && LOWER("search_value');

I just checked out your channel. (cool track) To muse means to become lost in thought. ua-cam.com/video/L70yH6g3P7s/v-deo.html

Send me a link so I can hear his voice.

Thank you.

Thanks for taking the time to watch and comment on this video. Truly appreciated.

Glad to hear this video was helpful. Appreciate you leaving a comment.

Hey @khizerhayyat549, thanks for the comment, much appreciated.

Glad you enjoyed it. And thanks for posting a comment.

Hey @jahbyke, thanks for comment. I appreciate the motivation to keep going, and thank you for subscribing to the channel.

Thank you. Glad to hear it was helpful.

Thanks a lot @TheGladiator123, appreciate you taking the time to write a comment, and hope this video was helpful.

@@SoftwareNuggets just if you can I would like to see more implementation of This function in solving more complex/ real world problem Also A Question: Can I use This user defined function to create a new column in the table

@@TheGladiator123 watch these video's I created using the function. I think you'll be impressed, and you'll become the master! --deck of cards (great skill to learn) ua-cam.com/video/7U129er3MYQ/v-deo.html --table valued function ua-cam.com/video/9aXD69xBvMs/v-deo.html --insert stored procedure ua-cam.com/video/jOyYhwxMGpg/v-deo.html --cursor in a function ua-cam.com/video/o4blx6Ij5S8/v-deo.html --how to write a scalar function ua-cam.com/video/2DtPEXjnxs4/v-deo.html --return a rowtype ua-cam.com/video/hOe3bi_nUYA/v-deo.html --convert ip address to big int ua-cam.com/video/SVlWmjM4sWk/v-deo.html

@@TheGladiator123 here is a function to allow you to add a column to a table. CREATE OR REPLACE FUNCTION fn_add_column_to_table(table_name VARCHAR, column_name VARCHAR, the_data_type VARCHAR, size INT) RETURNS VARCHAR AS $$ BEGIN IF size IS NOT NULL THEN EXECUTE format('ALTER TABLE %I ADD COLUMN %I %s(%s)', table_name, column_name, the_data_type, size); ELSE EXECUTE format('ALTER TABLE %I ADD COLUMN %I %s', table_name, column_name, the_data_type); END IF; RETURN 'Column added successfully'; END; $$ LANGUAGE plpgsql;

​@@SoftwareNuggets hey king Just Your Opinion I wa trying to implement what I learned From You But got Stucked At This edge Case Where I let The User pass an arraay OF words To a Colum with The Type VARCHAR(225) I still Got errors and I can't change The Column Defination

Great. Let me know how it goes!

hey @sajali1954 I think this video might help you. ua-cam.com/video/oGzRHlnhIFw/v-deo.html if it doesn't answer your question, I have about 30 shorts videos (less than 1 minute each), all about JSON. Here is a link to the playlist about JSON. ua-cam.com/play/PLRU_t-SgTrYgEyj0rCpDX30J0ombkf1kO.html Please let me know is if you found help, or you still need a solution. Scott

Hey @VishalMax-vv2qf, did you get the source from my github account? Is this the SQL statement you need me to explain: select name, occupation, row_number() over(partition by occupation order by occupation asc, [name] asc ) as num from #occupations

Thanks!

Are you asking, other than LANGUAGE plpgsql, what other languages can you use?

Thanks Alberto

Hey @rodf1021, I want to thank you for taking the time to leave a comment. Your input is greatly appreciated.

Can you send me a little part of your xml?

Send to softwareNugget65@gmail.com

Did you watch this video i created? ua-cam.com/video/JTZHPPJKinU/v-deo.html

@@SoftwareNuggets Thank you for the video, I coped with this, if you are interested in what was wrong with my code, I can additionally write to you

Hey Максим, I sent you an email with how to parse the XML you sent me! Hope that example helps. --scott

Thanks for the sub! I just viewed: ua-cam.com/users/shortsASf5JpYEf5I on your channel. Nice short.

Hey @saulocpp, for sure. dataGridView1.ReadOnly = false; dataGridView1.CellDoubleClick += DataGridView1_CellDoubleClick; dataGridView1.CellEndEdit += DataGridView1_CellEndEdit; private void DataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && e.ColumnIndex >= 0) { dataGridView1.BeginEdit(true); } } private void DataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { // Update the underlying data source // For example, if you're using a DataTable as the DataSource // you would update the corresponding DataRow here }

@@SoftwareNuggets I will definitely try your suggestions and adapt to WPF DataGrid accordingly... after I finish watching one more of your tutorials. 😅

I hope these videos help. Thanks for the feedback.

thanks

Can you write down the json you want, “key”: “value”, the key is the name of the field, the value is just that, the value. A value can be a string, a date, … or an OBJECT. I have many videos about is on my channel. Plz watch several of them to help you. If you still need help, I will be here. Plz leave a comment on each video you watch, so I know what you should have learned. Don’t worry, we will teach you what you need to know!